Respected sir,
select SOMainId,
case
when isMailsent=0 then
'<a href="#" onclick="var r=confirm(''Are you Sure!''); if (r==true){
modelPopupValues.push([''Trans_id'', ''' + CONVERT(varchar(255), dbo.SOMain.SOMainId) + ''']);
modelPopupValues.push([''VchType'', ''' + CONVERT(varchar(255), dbo.SOMain.VchType) + ''']);
ModalPagePopup(90,''Mail'','',true,true,600,600,'',true)};gettablelist();"> <i class="fa fa-envelope fa-lg" aria-hidden="true"> </a>'
when isMailsent=1 then '<i class="fa fa-envelope-open fa-lg" aria-hidden="true"> </a>'
end AS M
, MailSent ,
VCHNo, VCHDate,DespatchFrom,BAddressLineOne,BAddressLineTwo,BAddressLineThree,BCountryId,BStateId,BCityId,BMailingName,BPincode,BRegistrationType,BGSTINUIN,BPlaceofSupply,BPartytype,SMailingName,SAddressLineOne,SAddressLineTwo,SAddressLineThree,SCountryId,SStateId,SCityId,SPincode,SRegistrationType,SGSTINUIN,Agent,TransportName,BilledtoId,ShippedToId,UniqueGuid,TestHead,kz_CompanyId,kz_LocationId,kz_UserId,kz_CreatedUserId from SOMain with (Nolock)
I am using the above code.
case
when isMailsent=0 then
'<a href="#" onclick="var r=confirm(''Are you Sure!''); if (r==true){
modelPopupValues.push([''Trans_id'', ''' + CONVERT(varchar(255), dbo.SOMain.SOMainId) + ''']);
modelPopupValues.push([''VchType'', ''' + CONVERT(varchar(255), dbo.SOMain.VchType) + ''']);
ModalPagePopup(90,''Mail'','',true,true,600,600,'',true)};gettablelist();"> <i class="fa fa-envelope fa-lg" aria-hidden="true"> </a>'
when isMailsent=1 then '<i class="fa fa-envelope-open fa-lg" aria-hidden="true"> </a>'
end AS M
in ModalPopPopup I face in new Version.
Older Version Work Properly.