public BindResponseData BindData(BindJsonData obj2)
{
try
{
BindResponseData res = new BindResponseData();
//CountResponseData res = new CountResponseData();
List <BindBankRole> GridBindlist = new List <BindBankRole>();
var Result = dbcontext.MultipleResults("[dbo].[Sp_CreateUser]").With <BindBankRole>().
Execute("@QueryType", "@EntityId", "@AppId", "@SearchText", "BindUserRoles", Dbsecurity.Decrypt(HttpContext.Current.Server.UrlDecode(obj2.EntityId.Replace("_", "%"))), Dbsecurity.Decrypt(obj2.AppId), obj2.SearchText);
res.GridBindlist = Result[0].Cast <BindBankRole>().ToList();
return(res);
}
catch (Exception ex)
{
throw ex;
}
}
//Grid Bind Data
public Dictionary <string, object> GetData(GetDTCls gtdt)
{
try
{
var Data = Common.Getdata(dbcontext.MultipleResults("[dbo].[Sp_BranchMaster]").With <BrachMasterAttribute>().With <PageCountAtrribute>().Execute("@QueryType", "@AppId", "@EntityId", "@PageCount", "@SearchText", "GetData", gtdt.AppId, Dbsecurity.Decrypt(HttpContext.Current.Server.UrlDecode(gtdt.EntityId.Replace("_", "%"))), gtdt.PageCount, gtdt.SearchText));
return(Data);
}
catch (Exception ex)
{
throw ex;
}
}
public Dictionary <string, object> BindGrid([FromBody] RequestFields Data)
{
try
{
var Result = Common.Getdata(context.MultipleResults("[dbo].[Sp_FrontUnProcessedMandate]").With <BindFields>().With <RequestFields>().Execute("@QueryType", "@Status", "BindFrontGrid", Data.Status)); //Dbsecurity.Decrypt(Data.UserId), Dbsecurity.Decrypt(Data.EntityId)
return(Result);
}
catch (Exception ex)
{
throw ex;
}
}
public Dictionary <string, object> FetchData(RequestFields Data)
{
try
{
var Result = Common.Getdata(context.MultipleResults("[dbo].[Sp_CorporateRequest]").With <BindGridFields>().Execute("@QueryType", "@UserId", "@EntityId", "FetchData", "2", "2")); //Dbsecurity.Decrypt(Data.UserId), Dbsecurity.Decrypt(Data.EntityId)
return(Result);
}
catch (Exception ex)
{
throw ex;
}
}
public Dictionary <string, object> BindHeader()
{
try
{
var Result = Common.Getdata(dbcontext.MultipleResults("[dbo].[Proc_BISE]").With <BISEHeader>().Execute("@QueryType", "Header"));
return(Result);
}
catch (Exception ex)
{
throw ex;
}
}
//public Dictionary<string, object> BindHeader()
//{
// try
// {
// var Result = Common.Getdata(dbcontext.MultipleResults("[dbo].[Proc_BISE]").With<BISEHeader>().Execute("@QueryType", "Header"));
// return Result;
// }
// catch (Exception ex)
// {
// throw ex;
// }
//}
public Dictionary <string, object> BindDetails()
{
try
{
var Result = Common.Getdata(dbcontext.MultipleResults("[dbo].[sp_Temp_BulkImageExcelReceivingApproval]").With <BISEDetails>().Execute("@QueryType", "Details"));
return(Result);
}
catch (Exception ex)
{
throw ex;
}
}
public static UpdateResponseData UpdateData(UpdateJsonData obj1)
{
try
{
QuickCheck_AngularEntities dbcontext = new QuickCheck_AngularEntities();
UpdateResponseData res = new UpdateResponseData();
List <UpdateData> UpdateDatalist = new List <UpdateData>();
// List<Count> MandateCountlist = new List<Count>();
var Result = dbcontext.MultipleResults("[dbo].[Sp_ProductMaster]").With <UpdateData>().
Execute("@QueryType", "@ProductCode", "@ProductName", "@AppId", "@EntityId", "@UserId", "@ProductId", "UpdateData", obj1.code, obj1.name, obj1.AppId, Dbsecurity.Decrypt(HttpContext.Current.Server.UrlDecode(obj1.EntityId.Replace("_", "%"))), Dbsecurity.Decrypt(HttpContext.Current.Server.UrlDecode(obj1.UserId.Replace("_", "%"))), obj1.ProductId);
res.UpdateDatalist = Result[0].Cast <UpdateData>().ToList();
//res.UpdateDatalist = Result[0].Cast<UpdateData>().ToList();
return(res);
}
catch (Exception ex)
{
throw ex;
}
}
public static BindResponseData BindData(BindJsonData obj2)
{
try
{
QuickCheck_AngularEntities dbcontext = new QuickCheck_AngularEntities();
BindResponseData res = new BindResponseData();
//CountResponseData res = new CountResponseData();
List <GridBind> GridBindlist = new List <GridBind>();
List <Count> BindCountlist = new List <Count>();
var Result = dbcontext.MultipleResults("[dbo].[Sp_ProductMaster]").With <GridBind>().With <Count>().
Execute("@QueryType", "@PageCount", "@SearchText", "@AppId", "@EntityId", "BindGrid", obj2.PageCount, obj2.SearchText, obj2.AppId, Dbsecurity.Decrypt(HttpContext.Current.Server.UrlDecode(obj2.EntityId.Replace("_", "%"))));
res.GridBindlist = Result[0].Cast <GridBind>().ToList();
res.BindCountlist = Result[1].Cast <Count>().ToList();
return(res);
}
catch (Exception ex)
{
throw ex;
}
}
public SaveResponseData1 SaveData(SaveJsonData1 obj)
{
try
{
QuickCheck_AngularEntities dbcontext = new QuickCheck_AngularEntities();
SaveResponseData1 res = new SaveResponseData1();
string[] sponsorcodearr = obj.sponsorcodearr;
string StatesId = "";
for (int i = 0; i < sponsorcodearr.Length; i++)
{
StatesId += sponsorcodearr[i];
StatesId += ",";
}
StatesId = StatesId.TrimEnd(',');
List <SaveJsonData1> InsertDatalist = new List <SaveJsonData1>();
// List<Count> MandateCountlist = new List<Count>()
var Result = dbcontext.MultipleResults("[dbo].[Sp_RegionMaster]").With <InsertData>().
Execute("@QueryType", "@RegionCode", "@RegionName", "@strTable", "@AppId", "@EntityId", "@UserId", "InsertData", obj.RegionCode, obj.RegionName, StatesId, obj.AppId, Dbsecurity.Decrypt(HttpContext.Current.Server.UrlDecode(obj.EntityId.Replace("_", "%"))), Dbsecurity.Decrypt(HttpContext.Current.Server.UrlDecode(obj.UserId.Replace("_", "%"))));
res.InsertDatalist = Result[0].Cast <InsertData>().ToList();
return(res);
}
catch (Exception ex)
{
throw ex;
}
}
public string GetEncryptedmandateId(GetMandateReq Data)
{
string URl = "";
string TempId = "";
try
{
TempId = Dbsecurity.Decrypt(Data.AppId) + Dbsecurity.Decrypt(Data.MandateId);
TempId = Global.ReverseString(TempId);
TempId = Global.CreateRandomCode(6) + TempId;
List <GetCredential> GetCredentialList = new List <GetCredential>();
QuickCheck_AngularEntities dbcontext = new QuickCheck_AngularEntities();
var Result = dbcontext.MultipleResults("[dbo].[Sp_GetMandatemodeData]").With <GetCredential>().
Execute("@QueryType", "@AppId", "GetEntityCredential", Dbsecurity.Decrypt(Data.AppId));
GetCredentialList = Result[0].Cast <GetCredential>().ToList();
try
{
dbcontext = new QuickCheck_AngularEntities();
var Result1 = dbcontext.MultipleResults("[dbo].[sp_ESign]").With <doneres>().
Execute("@QueryType", "@MandateId", "@WebAppUrl", "@EncodedMandateID", "@AppId", "@EncodedAppId", "SaveLinkWithoutSMS", Dbsecurity.Decrypt(Data.MandateId), GetCredentialList[0].EWebAppUrl, TempId, Dbsecurity.Decrypt(Data.AppId), Data.AppId);
URl = "/MandateDetails?ID=" + TempId + "&AppId=" + Data.AppId;
// string WebAppUrl = ConfigurationManager.AppSettings["EWebAppUrl"].ToString();
// CommonManger.FillDatasetWithParam("sp_ESign", );
}
catch (Exception ex) { }
}
catch (Exception ex)
{ return("0"); }
return(URl);
}
public static GetMandateDataResponseData SetData()
{
try
{
QuickCheck_AngularEntities dbcontext = new QuickCheck_AngularEntities();
GetMandateDataResponseData res = new GetMandateDataResponseData();
List <GetMonth> GetMonthlist = new List <GetMonth>();
List <GetYear> GetYearlist = new List <GetYear>();
var Result = dbcontext.MultipleResults("[dbo].[sp_MandateAnalysis]").With <GetMonth>().With <GetYear>().
Execute("@QueryType", "GetMonthAndYear");
res.GetMonthlist = Result[0].Cast <GetMonth>().ToList();
res.GetYearlist = Result[1].Cast <GetYear>().ToList();
return(res);
}
catch (Exception ex)
{
//return null;
throw ex;
}
}
public static GridExportExcelResponseData1 BindExportExcelData1(BindExportExcelJsonData1 obj3)
{
try
{
QuickCheck_AngularEntities dbcontext = new QuickCheck_AngularEntities();
GridExportExcelResponseData1 res = new GridExportExcelResponseData1();
//CountResponseData res = new CountResponseData();
List <GridExportExcelBind1> GridBindExportlist1 = new List <GridExportExcelBind1>();
var Result = dbcontext.MultipleResults("[dbo].[Sp_RegionMaster]").With <GridExportExcelBind1>().
Execute("@QueryType", "@AppId", "@EntityId", "GetData", obj3.AppId, Dbsecurity.Decrypt(HttpContext.Current.Server.UrlDecode(obj3.EntityId.Replace("_", "%"))));
res.GridBindExportlist1 = Result[0].Cast <GridExportExcelBind1>().ToList();
return(res);
}
catch (Exception ex)
{
throw ex;
}
}
public gridlist BindGrid(MandateDetails data)
{
try
{
gridlist res = new gridlist();
List <BindGrid> BindGridlist = new List <BindGrid>();
// var Result = Common.Getdata(dbcontext.MultipleResults("[dbo].[Sp_Mandate]").With<BindGrid>().Execute("@QueryType", "@UserId", "@AppId", "@ToDate"
//, "@FromDate", "grdMandateDataDateWise", Dbsecurity.Decrypt(HttpContext.Current.Server.UrlDecode(data.UserId.Replace("_", "%"))), data.AppId, data.ToDate, data.FromDate));
// BindGridlist = Result.Cast<BindGrid>().ToList();
var Result = dbcontext.MultipleResults("[dbo].[Sp_Mandate]").With <BindGrid>().Execute("@QueryType", "@UserId", "@AppId", "@ToDate"
, "@FromDate", "grdMandateDataDateWise", Dbsecurity.Decrypt(HttpContext.Current.Server.UrlDecode(data.UserId.Replace("_", "%"))), data.AppId, data.ToDate, data.FromDate);
BindGridlist = Result[0].Cast <BindGrid>().ToList();
for (var i = 0; i < BindGridlist.Count; i++)
{
BindGridlist[i].AcNo = Dbsecurity.Decrypt(Convert.ToString(BindGridlist[i].AcNo));
BindGridlist[i].Amount_Numeric = Dbsecurity.Decrypt(Convert.ToString(BindGridlist[i].Amount_Numeric));
BindGridlist[i].EncryptMandateId = Dbsecurity.Encrypt(Convert.ToString(BindGridlist[i].MandateFreshId));
}
res.BindGridlist = BindGridlist;
return(res);
}
catch (Exception ex)
{
throw ex;
}
}
public static BindaResponseData GetData(GetDatavalue obj)
{
try
{
QuickCheck_AngularEntities dbcontext = new QuickCheck_AngularEntities();
BindaResponseData res = new BindaResponseData();
List <GridBind> Gridlist = new List <GridBind>();
List <Count> BindCountlist = new List <Count>();
var Result = dbcontext.MultipleResults("[dbo].[Sp_RegionMaster]").With <GridBind>().With <Count>().
Execute("@QueryType", "@PageCount", "@SearchText", "@AppId", "@EntityId", "GetData1", obj.PageCount, obj.SearchText, obj.AppId, Dbsecurity.Decrypt(HttpContext.Current.Server.UrlDecode(obj.EntityId.Replace("_", "%"))));
res.GridBindlist = Result[0].Cast <GridBind>().ToList();
res.BindCountlist = Result[1].Cast <Count>().ToList();
return(res);
}
catch (Exception ex)
{
//return null;
throw ex;
}
}
public Dictionary <string, object> GetMandateData(string ID)
{
try
{
List <GetMandateData> Gridlist = new List <GetMandateData>();
QuickCheck_AngularEntities dbcontext = new QuickCheck_AngularEntities();
var results = dbcontext.MultipleResults("[dbo].[sp_Temp_BulkImageExcelReceivingApproval]").With <GetMandateData>()
.Execute("@Querytype", "@BIBE_Count", "GetMandateData", ID);
Gridlist = results[0].Cast <GetMandateData>().ToList();
DataTable dt = new DataTable();
dt = ToDataTable(Gridlist);
//foreach (DataRow row in dt.Rows)
//{
// row["BankACNumber"] = Dbsecurity.Decrypt(Convert.ToString(row["AcNo"]));
// row["Amount"] = Dbsecurity.Decrypt(Convert.ToString(row["AmountRupees"]));
// row["PhoneNumber"] = Dbsecurity.Decrypt(Convert.ToString(row["PhoneNumber"]));
// row["EmailID"] = Dbsecurity.Decrypt(Convert.ToString(row["EmailId"]));
//}
DataSet ds = new DataSet();
ds.Tables.Add(dt);
return(ClsJson.JsonMethods.ToJson(ds));
}
catch (Exception ex)
{
throw ex;
}
}
public static string SendMailCount(string MandateID, string AppId, string EmailCount, string SmsCount, int SMSLength, string MessageRequestId)
{
string status = "";
try
{
//SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings[Convert.ToString(AppId)].ConnectionString);
//string query = "Sp_SendEmail";
//SqlCommand cmd = new SqlCommand(query, con);
//cmd.CommandType = CommandType.StoredProcedure;
//cmd.Parameters.AddWithValue("@QueryType", "SendMail");
//cmd.Parameters.AddWithValue("@MandateID", MandateID);
//cmd.Parameters.AddWithValue("@EmailCount", EmailCount);
//cmd.Parameters.AddWithValue("@SmsCount", SmsCount);
//cmd.Parameters.AddWithValue("@SMSLength", SMSLength);
//cmd.Parameters.AddWithValue("@MessageRequestId", MessageRequestId);
QuickCheck_AngularEntities dbcontext = new QuickCheck_AngularEntities();
var Result = dbcontext.MultipleResults("[dbo].[Sp_SendEmail]").With <doneres>().
Execute("@QueryType", "@MandateID", "@EmailCount", "@SmsCount", "@SMSLength", "@MessageRequestId", "@AppId", "SendMail", MandateID, EmailCount, SmsCount, SMSLength.ToString(), MessageRequestId, AppId);
}
catch (Exception ex)
{
Console.Out.WriteLine("-----------------");
Console.Out.WriteLine(ex.Message);
return(ex.Message);
}
return(status);
}
public static GetMandateDataResponseData PhysicalSearchData(GetMandateData objectname)
{
try
{
QuickCheck_AngularEntities dbcontext = new QuickCheck_AngularEntities();
GetMandateDataResponseData res = new GetMandateDataResponseData();
List <GridData> GridDatalist = new List <GridData>();
List <Count> MandateCountlist = new List <Count>();
var Result = dbcontext.MultipleResults("[dbo].[sp_MandateAnalysis]").With <GridData>().With <Count>().
Execute("@QueryType", "@Month", "@Year", "@topVal", "GetMandateData_Physical", objectname.Month, objectname.Year, objectname.Total);
res.GridDatalist = Result[0].Cast <GridData>().ToList();
res.MandateCountlist = Result[1].Cast <Count>().ToList();
return(res);
}
catch (Exception ex)
{
throw ex;
}
}
public static void QRGenerator(string MandateID, string EntityId, string Refrence1, string AppId)
{
QuickCheck_AngularEntities dbcontext = new QuickCheck_AngularEntities();
string code = MandateID + "_" + Refrence1;
QRCodeGenerator qrGenerator = new QRCodeGenerator();
QRCodeGenerator.QRCode qrCode = qrGenerator.CreateQrCode(code, QRCodeGenerator.ECCLevel.H);
System.Web.UI.WebControls.Image imgBarCode = new System.Web.UI.WebControls.Image();
imgBarCode.Height = 250;
imgBarCode.Width = 250;
using (Bitmap bitMap = qrCode.GetGraphic(20))
{
using (MemoryStream ms = new MemoryStream())
{
bitMap.Save(ms, System.Drawing.Imaging.ImageFormat.Png);
byte[] byteImage = ms.ToArray();
imgBarCode.ImageUrl = "data:image/png;base64," + Convert.ToBase64String(byteImage);
string result = Convert.ToBase64String(byteImage, 0, byteImage.Length);
string check = CreateImage(result.ToString(), MandateID, AppId);
if (check != "")
{
var Result = dbcontext.MultipleResults("[dbo].[Sp_Mandate]").Execute("@QueryType", "@EntityId", "@MandateId", "@QRCodeImagepath", "QRCodeImagepath", EntityId, MandateID, check);
}
}
}
}
public static string UpdateIsPHysical(string MandateId, string UserId, String AppId)
{
QuickCheck_AngularEntities dbcontext = new QuickCheck_AngularEntities();
var Result = dbcontext.MultipleResults("[dbo].[Sp_Mandate]").With <UpdateNameRes>().
Execute("@QueryType", "@MandateId", "@AppId", "@UserId", "UpdateIsPHysical", MandateId, AppId, Dbsecurity.Decrypt(UserId));
return("1");
}
public static IEnumerable <pennyDetails> Getpennydata(string IFSC, string AppId)
{
QuickCheck_AngularEntities dbcontext = new QuickCheck_AngularEntities();
List <pennyDetails> nn = new List <pennyDetails>();
var Result = dbcontext.MultipleResults("[dbo].[sp_GetPennydropdetails]").With <pennyDetails>().Execute("@QueryType", "@Ifsc", "@AppId", "getpennydata", IFSC, AppId);
nn = Result[0].Cast <pennyDetails>().ToList();
return(nn);
}
public Dictionary <string, object> GetPageLoaddata(UserEntity data)
{
try
{
var Result = Common.Getdata(dbcontext.MultipleResults("[dbo].[Sp_Mandate]").With <BindEntityDetails>().With <BindLogoImageDetails>().With <BindBankNameDetails>().With <BindSponserCode>().With <BindBankUtilityCode>().With <BindBankPaymentMode>().With <BindEntityDetailsdata>().With <BindDebitType>().With <Bindfrequency>().With <BindEntityPeriods>().With <BindEntitydebitcredit>().With <BindEntityCategorytype>().With <BindLogincheck>().With <BindProductDropDown>().Execute("@QueryType", "@UserId", "@EntityId", "@AppId", "UserData", Dbsecurity.Decrypt(data.UserId), Dbsecurity.Decrypt(data.EntityId), Dbsecurity.Decrypt(data.AppId)));
return(Result);
}
catch (Exception ex)
{
throw ex;
}
}
public static string getTraceNo(string AppId)
{
QuickCheck_AngularEntities dbcontext = new QuickCheck_AngularEntities();
List <InsertrequestNOModel> InsertrequestNOModelllist = new List <InsertrequestNOModel>();
var Result = dbcontext.MultipleResults("[dbo].[sp_Payment]").With <InsertrequestNOModel>().Execute("@QueryType", "@AppId", "getTraceNo", AppId);
InsertrequestNOModelllist = Result[0].Cast <InsertrequestNOModel>().ToList();
return(Convert.ToString(InsertrequestNOModelllist[0].RequestNo));
}
public Dictionary <string, object> GetMandateDetails(MandateHeader data)
{
try
{
TempMandateID = Convert.ToString(data.MandateId);
TempMandateID = TempMandateID.Substring(6, TempMandateID.Length - 6);
TempMandateID = EntityDAL.Global.ReverseString(TempMandateID);
TempMandateID = TempMandateID.Substring(6, TempMandateID.Length - 6);
var Result = Common.Getdata(dbcontext.MultipleResults("[dbo].[sp_MandateDetails]").With <MandateDetailList>().With <MandateDetailList1>().Execute("@QueryType", "@MandateId", "@Link", "@AppId", "MandateDetails", TempMandateID, data.URL, data.AppId));
Result.Add("TempMandateID", TempMandateID);
return(Result);
}
catch (Exception ex)
{
throw ex;
}
}
public static string UpdateName(UpdateName Data)
{
QuickCheck_AngularEntities dbcontext = new QuickCheck_AngularEntities();
//int value = CommonManger.IntMethodWithParam("sp_Payment", "@QueryType", "@Type",
// "@MandateId",
// "UpdateName", rdoName.SelectedValue, ViewState["id"].ToString());
var Result = dbcontext.MultipleResults("[dbo].[sp_Payment]").With <UpdateNameRes>().
Execute("@QueryType", "@Type", "@MandateId", "@Appid", "UpdateName", Data.RadioValue, Dbsecurity.Decrypt(Data.MandateId), Dbsecurity.Decrypt(Data.AppId));
return("1");
}
public Dictionary <string, object> BindData(string EntityId)
{
try
{
var Result = Common.Getdata(dbcontext.MultipleResults("[dbo].[Sp_CreateUser]").With <BindUtilityCode>().With <Sponsorbankcode>().With <CategoryCode>().With <BindClientCode>().With <Product>().With <Region>().With <Branch>().Execute("@QueryType", "@EntityId", "BindData", Dbsecurity.Decrypt(HttpContext.Current.Server.UrlDecode(EntityId.Replace("_", "%")))));
return(Result);
}
catch (Exception ex)
{
throw ex;
}
}
public IEnumerable <ResponseFlag> FinalUploadCropImage(UploadMandateModel context)
{
List <ResponseFlag> common = new List <ResponseFlag>();
ResponseFlag Flag = new ResponseFlag();
try
{
string croppedFileName = string.Empty;
string filePath = string.Empty;
string ID = Convert.ToString(Dbsecurity.Decrypt(context.MdtID));
string No = Convert.ToString(Dbsecurity.Decrypt(context.RefrenceNo));
string APPId = Convert.ToString(Dbsecurity.Decrypt(context.AppID));
string UserId = Convert.ToString(Dbsecurity.Decrypt(context.UserId));
string JPGFilepath = string.Empty;
croppedFileName = ConfigurationManager.AppSettings["DownloadFileName" + APPId].ToString() + "_" + DateTime.Now.ToString("ddMMyyyy") + "_" + No + ".tif";
filePath = "../MandateFile/" + APPId + "/" + ID + "/" + croppedFileName;
string MandateId = ID;
if (File.Exists(HttpContext.Current.Server.MapPath("~/MandateFile/" + APPId + "/" + MandateId + "/" + ConfigurationManager.AppSettings["DownloadFileName"].ToString() + "_" + DateTime.Now.ToString("ddMMyyyy") + "_" + Convert.ToString(No) + ".tif")) && File.Exists(HttpContext.Current.Server.MapPath("~/MandateFile/" + APPId + "/" + MandateId + "/" + ConfigurationManager.AppSettings["DownloadFileName"].ToString() + "_" + DateTime.Now.ToString("ddMMyyyy") + "_" + Convert.ToString(No) + ".jpg")))
{
croppedFileName = ConfigurationManager.AppSettings["DownloadFileName" + APPId].ToString() + "_" + DateTime.Now.ToString("ddMMyyyy") + "_" + No + ".jpg";
JPGFilepath = "../MandateFile/" + APPId + "/" + ID + "/" + croppedFileName;
QuickCheck_AngularEntities dbcontext = new QuickCheck_AngularEntities();
List <GetLogo> dataList1 = new List <GetLogo>();
var Result2 = dbcontext.MultipleResults("[dbo].[Sp_Mandate]").With <GetLogo>().Execute("@QueryType", "@TIPPath", "@PNGPath", "@MandateId", "@UserId", "UpdatePNGTIP",
Convert.ToString(filePath), Convert.ToString(JPGFilepath), Convert.ToString(ID), Convert.ToString(UserId));
Flag.Flag = "1";
Flag.FlagValue = "Mandate uploaded successfully";
common.Add(Flag);
}
else
{
QuickCheck_AngularEntities dbcontext = new QuickCheck_AngularEntities();
List <GetLogo> dataList1 = new List <GetLogo>();
var Result2 = dbcontext.MultipleResults("[dbo].[Sp_Mandate]").With <GetLogo>().Execute("@QueryType", "@TIPPath", "@PNGPath", "@MandateId", "@UserId", "UpdatePNGTIP",
null, null, ID, UserId);
Flag.Flag = "1";
Flag.FlagValue = "Image is not Properly Uploaded,Please Upload again";
common.Add(Flag);
}
// }
}
catch (Exception ex)
{
Flag.Flag = "1";
Flag.FlagValue = "Image is not Properly Uploaded,Please Upload again";
common.Add(Flag);
}
return(common);
}
// List<BrachMasterAttribute> dataList = new List<BrachMasterAttribute>();
// BrachMasterAttribute cnjd = new BrachMasterAttribute();
public Dictionary <string, object> GetData()
{
try
{
var Data = Common.Getdata(dbcontext.MultipleResults("[dbo].[Sp_BranchMaster]").With <BrachMasterAttribute>().Execute("@QueryType", "GetData"));
return(Data);
}
catch (Exception ex)
{
throw ex;
}
}
public Dictionary <string, object> BindGrid(MandateRequest MandateRequestData)
{
try
{
var Result = Common.Getdata(context.MultipleResults("[dbo].[Sp_RBL_BackOffice]").With <MandateRequestData>().Execute("@QueryType", "@Userid", "BindUnProcessGrid", Dbsecurity.Decrypt(MandateRequestData.UserID)));
return(Result);
}
catch (Exception ex)
{
throw ex;
}
}
public static void UpdatePrintcount(string AppId, string MandateId, string UserId)
{
//int value = CommonManger.IntMethodWithParam("sp_Payment", "@QueryType", "@MandateId", "@UserId", "IncreaseCounter", ViewState["id"].ToString(), Convert.ToString(Iace.User.CurrentUser.User.UserId));
try
{
QuickCheck_AngularEntities dbcontext = new QuickCheck_AngularEntities();
List <UpdateNameRes> CutterImagList = new List <UpdateNameRes>();
var Result = dbcontext.MultipleResults("[dbo].[sp_Payment]").With <UpdateNameRes>().Execute("@QueryType", "@MandateId", "@UserId", "@AppId", "IncreaseCounter", MandateId, UserId, AppId);
}
catch (Exception ex)
{
}
}
public Dictionary <string, object> BindHeaderGrid(UserDetails data)
{
try
{
var results = Common.Getdata(dbcontext.MultipleResults("[dbo].[TEMPDESTPRESENT_Sponsor]").With <GridDataTable>()
.Execute("@Querytype", "@Status", "@EntityId", "@UserId", "BindHeaderGrid_Sponsor", data.status, Dbsecurity.Decrypt(data.EntityId), Dbsecurity.Decrypt(data.UserId)));
return(results);
}
catch (Exception ex)
{
throw ex;
}
}