public Dictionary <string, object> BindPiegrid(GraphBind Data) { FAMSEntities context = new FAMSEntities(); string fromdata = ""; string todate = ""; try { if (Data.Fromdate != "") { fromdata = Convert.ToDateTime(Data.Fromdate).ToString("yyyy-MM-dd"); } if (Data.Todate != null) { todate = Convert.ToDateTime(Data.Todate).ToString("yyyy-MM-dd"); } var results = Common.Getdata(context.MultipleResults("[dbo].[Pms_GraphBind]").With <BindpieCapitalStatement>().With <BindcolumnPieCapitalstatement>().Execute("@QueryType", "@FromDate", "@ToDate", "@CustomerAccount", "@Linkid", "@ReportType", "BindAllReport", fromdata, todate, Data.AccountNo, Data.Linkid, Data.ReportType)); return(results); } catch (Exception ex) { throw ex; } }
protected void btnDowloadExcel_Click(object sender, EventArgs e) { FAMSEntities context = new FAMSEntities(); List <SummaryReportExcel> dataList = new List <SummaryReportExcel>(); try { fromdate = hdnFromDate.Value; todate = hdnToDate.Value; var results = context.MultipleResults("[dbo].[Sp_DemoReport]").With <SummaryReportExcel>() .Execute("@Querytype", "@CustomerAccount", "@Fromdate", "@Todate", "GetSummaryReportDataExcel", Session["UserName"].ToString(), fromdate, todate); foreach (var data in results) { dataList = data.Cast <SummaryReportExcel>().ToList(); } DataTable dt = ToDataTable(dataList); string filename = "Excel"; CreateExcel(dt, filename); } catch (Exception ex) { throw ex; } }
public Dictionary <string, object> SaveData(JsonAllFields Data) { string Active = ""; if (Data.Active == true) { Active = "1"; } else { Active = "0"; } FAMSEntities context = new FAMSEntities(); try { string Password = string.Empty; Password = Dbsecurity.Encrypt(Data.Emailid.Split('@').ElementAtOrDefault(0)); var results = Common.Getdata(context.MultipleResults("[dbo].[Sp_PMSEmployees]").With <CommonFields>() .Execute("@Querytype", "@EmployeeCode", "@EmployeeName", "@Gender", "@About", "@Custodian", "@CustomerCode", "@CustomerName", "@EmpLinkingDate", "@Qualification", "@InceptionDate", "@PMSEmpId", "@Active", "@UserId", "@EmailId", "@Password", "SaveEmployee", Data.EmployeeCode, Data.EmployeeName, Data.Gender, Data.About, Data.Custodian, Data.CustomerCode, Data.CustomerName, Data.EmpLinkingDate, Data.Qualification, Data.InceptionDate, Data.PMSEmpId, Active, Dbsecurity.Decrypt(HttpContext.Current.Server.UrlDecode(Data.UserId.Replace("_", "%"))), Data.Emailid, Password)); return(results); } catch (Exception ex) { throw ex; } }
public IEnumerable <CustomerResponse> SaveCustomer(JsonCustomerDetails Data, string UserId) { FAMSEntities context = new FAMSEntities(); CustomerResponse ObjCustResponse = new CustomerResponse(); try { string Password = string.Empty; List <CustomerResponse> dataList = new List <CustomerResponse>(); Password = Dbsecurity.Encrypt(Data.CustomerEmailID.Split('@').ElementAtOrDefault(0)); var results = context.MultipleResults("[dbo].[Sp_user]").With <CustomerResponse>().Execute("@QueryType", "@UserId", "@UserName", "@AccountNo", "@EmailId", "@Password", "@pmsempid", "SaveData", Dbsecurity.Decrypt(UserId).ToString(), Data.CustomerUsername.ToString(), Data.CustomerAccount.ToString(), Data.CustomerEmailID.ToString(), Password.ToString(), Data.EmployeeCode.ToString()); //results.tab dataList = results.FirstOrDefault().Cast <CustomerResponse>().ToList(); if (dataList.Cast <CustomerResponse>().ToList().Select(x => x.value).First().ToString() == "1") { using (StringWriter sw = new StringWriter()) { using (HtmlTextWriter hw = new HtmlTextWriter(sw)) { StringBuilder sb = new StringBuilder(); string WebAppUrl = ConfigurationManager.AppSettings["WebAppUrl"].ToString(); string SMTPHost = ConfigurationManager.AppSettings["SMTPHost"].ToString(); string FromMailId = ConfigurationManager.AppSettings["UserId"].ToString(); string MailPassword = ConfigurationManager.AppSettings["MailPassword"].ToString(); string SMTPPort = ConfigurationManager.AppSettings["SMTPPort"].ToString(); string SMTPEnableSsl = ConfigurationManager.AppSettings["SMTPEnableSsl"].ToString(); sb.Append("Dear " + (Data.CustomerUsername).ToString() + ",<br> <br>"); sb.Append("Please find your new Password is -- " + Dbsecurity.Decrypt(Password).ToString() + " <br> <br>"); SmtpClient smtpClient = new SmtpClient(); MailMessage mailmsg = new MailMessage(); MailAddress mailaddress = new MailAddress(FromMailId); mailmsg.To.Add((Data.CustomerEmailID).ToString()); mailmsg.From = mailaddress; mailmsg.Subject = "User New Password"; mailmsg.IsBodyHtml = true; mailmsg.Body = sb.ToString(); smtpClient.Host = SMTPHost; smtpClient.Port = Convert.ToInt32(SMTPPort); smtpClient.EnableSsl = Convert.ToBoolean(SMTPEnableSsl); smtpClient.UseDefaultCredentials = true; smtpClient.Credentials = new System.Net.NetworkCredential(FromMailId, MailPassword); smtpClient.Send(mailmsg); //QuickCheck_AngularEntities dbcontext = new QuickCheck_AngularEntities(); //dbcontext.MultipleResults("[dbo].[Sp_SendEmail]").With<Responsevalue>().Execute("@QueryType", "@MandateId", "@EmailCount", "@SmsCount", "SendMail", Convert.ToString(0), "1", "0"); } } } return(dataList); } catch (Exception ex) { throw ex; } }
public Dictionary <string, object> BindGrid3(JsonUserDetails Data) { FAMSEntities context = new FAMSEntities(); try { var results = Common.Getdata(context.MultipleResults("[dbo].[Sp_user]").With <Customer>().Execute("@QueryType", "@pmsempid", "BindGraphDUser", Data.UserId)); return(results); } catch (Exception ex) { throw ex; } }
public Dictionary<string, object> BindDefaultData(GridFields Data) { FAMSEntities context = new FAMSEntities(); try { var results = Common.Getdata(context.MultipleResults("[dbo].[SP_PortfolioAppraisal]").With<PageLoadData>() .Execute("@Querytype", "@CustomerAccount", "@GUserId", "GetDefault_PortfolioAppraisal", Data.CustomerAccountno, Dbsecurity.Decrypt(Data.UserID))); return results; } catch (Exception ex) { throw ex; } }
public Dictionary<string, object> BindCustomer(string EmployeeId) { FAMSEntities context = new FAMSEntities(); try { var results = Common.Getdata(context.MultipleResults("[dbo].[SP_PortfolioAppraisal]").With<Customer>() .Execute("@Querytype", "@EmployeeId", "GetCustomer", EmployeeId)); return results; } catch (Exception ex) { throw ex; } }
public Dictionary <string, object> BindGrid(string UserId) { FAMSEntities context = new FAMSEntities(); try { var results = Common.Getdata(context.MultipleResults("[dbo].[Sp_user]").With <CustomerDetails>().Execute("@QueryType", "@UserId", "BindUser", Dbsecurity.Decrypt(UserId).ToString())); return(results); } catch (Exception ex) { throw ex; } }
public Dictionary <string, object> BindGGrid() { FAMSEntities context = new FAMSEntities(); try { var results = Common.Getdata(context.MultipleResults("[dbo].[Sp_user]").With <Employee>().With <Customer>().With <ReportLink>().Execute("@QueryType", "BindGraphUser")); return(results); } catch (Exception ex) { throw ex; } }
public Dictionary<string, object> NextRecordBind(string CustomerAccount, string FromDate, string ToDate, string SeqNo) { FAMSEntities context = new FAMSEntities(); try { var results = Common.Getdata(context.MultipleResults("[dbo].[SP_PortfolioAppraisal]").With<PageLoadData>() .Execute("@Querytype", "@CustomerAccount", "@FromDate", "@SeqNo", "NextRecordBind", CustomerAccount, FromDate, SeqNo)); return results; } catch (Exception ex) { throw ex; } }
public Dictionary <string, object> BindTransactionStatementView(JsonFieldsTS Data) { FAMSEntities context = new FAMSEntities(); try { var results = Common.Getdata(context.MultipleResults("[dbo].[Sp_TransactionStatement]").With <TransactionStatementView>() .Execute("@Querytype", "@ReportType", "@FromDate", "@ToDate", "@CustomerAccount", "GetTransactionStatement_View", Data.ReportType, Data.FromDate, Data.ToDate, Data.CustomerAccount)); return(results); } catch (Exception ex) { throw ex; } }
public Dictionary <string, object> BindDefaultData(string CustomerAccount, string GUserId) { FAMSEntities context = new FAMSEntities(); try { var results = Common.Getdata(context.MultipleResults("[dbo].[Sp_TransactionStatement]").With <TransactionStatement_Default>() .Execute("@Querytype", "@CustomerAccount", "@GUserId", "GetDefault_TransactionStatemenet", CustomerAccount, Dbsecurity.Decrypt(GUserId.Replace(" ", "+")))); return(results); } catch (Exception ex) { throw ex; } }
public Dictionary <string, object> BindGrid(JsonFields Data) { FAMSEntities context = new FAMSEntities(); try { var results = Common.Getdata(context.MultipleResults("[dbo].[Sp_PerformanceAppraisal]").With <BindmaingridHeader>().With <BindPortfolioAllocation>() .With <BindPortfolioSummary>().With <BindPortfolioPerformance>().With <BindPortfolioAllocationTotal>().Execute("@Querytype", "@CustomerAccount", "@AsOnDate", "@SeqNo", "BindAllGrid", Data.CustomerAccount, Data.AsOnDate, Data.SeqNo)); return(results); } catch (Exception ex) { throw ex; } }
public Dictionary <string, object> BindCustomer(string EmployeeId) { FAMSEntities context = new FAMSEntities(); try { var results = Common.Getdata(context.MultipleResults("[dbo].[Sp_DemoReport]").With <Customer>() .Execute("@Querytype", "@EmployeeId", "GetCustomerForStatementOfExp", EmployeeId)); return(results); } catch (Exception ex) { throw ex; } }
public Dictionary <string, object> BindCustomers(JsonData Data) { FAMSEntities context = new FAMSEntities(); try { var results = Common.Getdata(context.MultipleResults("[dbo].[Sp_BankBook]").With <BindCustomers>() .Execute("@Querytype", "@UserId", "BindCustomers", Data.UserId)); return(results); } catch (Exception ex) { throw ex; } }
public Dictionary <string, object> BindGrid(JsonFields Data) { FAMSEntities context = new FAMSEntities(); try { var results = Common.Getdata(context.MultipleResults("[dbo].[Sp_TrialBalanceReport]").With <GridAllFields>() .Execute("@Querytype", "@CustomerAccount", "@Fromdate", "@Todate", "@Accounts", "@AccountSubLayer", "BindGride", Data.CustomerAccount, Data.FromDate, Data.ToDate, Data.Account, Data.AccountSubLayer)); return(results); } catch (Exception ex) { throw ex; } }
//------------Added By Vimal(13 Aug ) For View Purpose-// public Dictionary <string, object> BindMainGridView(PrimaryDetails data) { FAMSEntities context = new FAMSEntities(); try { var results = Common.Getdata(context.MultipleResults("[dbo].[Sp_TransactionStatement]").With <BindMainGridViewdata>() .Execute("@Querytype", "@CustomerAccount", "@ReportType", "@Fromdate", "@Todate", "BindGridView_Common", data.accountNumber.Trim(), data.ReportName, data.Fromdate, data.Todate)); return(results); } catch (Exception ex) { throw ex; } }
public Dictionary <string, object> BindGrid(string FromDate, string ToDate) { FAMSEntities context = new FAMSEntities(); try { var results = Common.Getdata(context.MultipleResults("[dbo].[Sp_DemoReport]").With <StatementOfExpenses_DataAnalysic>().With <StatementOfExpenses1_DataAnalysic>() .Execute("@Querytype", "@FromDate", "@ToDate", "GetDataAnalysic_StatemenetOfExpenses", FromDate, ToDate)); return(results); } catch (Exception ex) { throw ex; } }
public Dictionary <string, object> BindAllCustomer() { FAMSEntities context = new FAMSEntities(); try { var results = Common.Getdata(context.MultipleResults("[dbo].[FAMS_SchemeMaster]").With <Customer>() .Execute("@Querytype", "BindAllCustomer")); return(results); } catch (Exception ex) { throw ex; } }
public Dictionary <string, object> BindCustomers(CommonFields Data) { FAMSEntities context = new FAMSEntities(); try { var results = Common.Getdata(context.MultipleResults("[dbo].[Sp_DemoReport]").With <BindCustomerAllFields>() .Execute("@Querytype", "GetCustomer")); //, Dbsecurity.Decrypt(HttpContext.Current.Server.UrlDecode(UserId.Replace("_", "%"))) return(results); } catch (Exception ex) { throw ex; } }
public Dictionary <string, object> BindGridView(JsonData Data) { FAMSEntities context = new FAMSEntities(); try { var results = Common.Getdata(context.MultipleResults("[dbo].[Sp_BankBook]").With <BindGridView>() .Execute("@Querytype", "@FromDate", "@ToDate", "@CustomerAccount", "@ReportType", "BindGridView", Data.FromDate, Data.ToDate, Data.CustomerAccount, Data.ReportType)); return(results); } catch (Exception ex) { throw ex; } }
public Dictionary <string, object> BindNextData(JsonData Data) { FAMSEntities context = new FAMSEntities(); try { var results = Common.Getdata(context.MultipleResults("[dbo].[Sp_BankBook]").With <PageLoadData>() .Execute("@Querytype", "@CustomerAccount", "@UserId", "@PageCount", "NextRecords", Data.CustomerAccount, Data.UserId, Data.PageCount)); return(results); } catch (Exception ex) { throw ex; } }
//public Dictionary<string, object> BindCustomer(string EmployeeId) //{ // FAMSEntities context = new FAMSEntities(); // try // { // var results = Common.Getdata(context.MultipleResults("[dbo].[Sp_DemoReport]").With<Customer>() // .Execute("@Querytype", "@EmployeeId", "GetCustomerForStatementOfExp", EmployeeId)); // return results; // } // catch (Exception ex) // { // throw ex; // } //} //public Dictionary<string, object> BindEmployees(string UserId) //{ // FAMSEntities context = new FAMSEntities(); // try // { // var results = Common.Getdata(context.MultipleResults("[dbo].[Sp_BankBook]").With<BindEmployees>() // .Execute("@Querytype", "@UserId", "BindEmployees", Dbsecurity.Decrypt(UserId))); // return results; // } // catch (Exception ex) // { // throw ex; // } //} public Dictionary <string, object> NextRecordBind(string CustomerAccount, string FromDate, string ToDate, string SeqNo) { FAMSEntities context = new FAMSEntities(); try { var results = Common.Getdata(context.MultipleResults("[dbo].[Sp_TransactionStatement]").With <TransactionStatement_Default>() .Execute("@Querytype", "@CustomerAccount", "@FromDate", "@ToDate", "@SeqNo", "NextRecordBind", CustomerAccount, FromDate, ToDate, SeqNo)); return(results); } catch (Exception ex) { throw ex; } }
public Dictionary <string, object> GetSummary(string CustomerAccount) { FAMSEntities context = new FAMSEntities(); try { var results = Common.Getdata(context.MultipleResults("[dbo].[Sp_TransactionStatement]").With <BindmaingridDetails_Summary>() .Execute("@Querytype", "@CustomerAccount", "Summary", CustomerAccount)); return(results); } catch (Exception ex) { throw ex; } }
public Dictionary<string, object> BindEmployees(string UserId) { FAMSEntities context = new FAMSEntities(); try { var results = Common.Getdata(context.MultipleResults("[dbo].[Sp_BankBook]").With<BindEmployees>() .Execute("@Querytype", "@UserId", "BindEmployees", Dbsecurity.Decrypt(UserId))); return results; } catch (Exception ex) { throw ex; } }
public Dictionary <string, object> BindCustomers(Fields Data) { FAMSEntities context = new FAMSEntities(); try { var results = Common.Getdata(context.MultipleResults("[dbo].[Sp_PMSEmployees]").With <BindAllCustomersFields>() .Execute("@Querytype", "@PMSEmpId", "@UserId", "BindCustomers", Data.PAMSEmpId, Dbsecurity.Decrypt(HttpContext.Current.Server.UrlDecode(Data.UserId.Replace("_", "%"))))); return(results); } catch (Exception ex) { throw ex; } }
public Dictionary <string, object> BindDefaultData(DefaultJson Data) { FAMSEntities context = new FAMSEntities(); try { var results = Common.Getdata(context.MultipleResults("[dbo].[Sp_BankBook]").With <PageLoadData>() .Execute("@Querytype", "@CustomerAccount", "@UserId", "GetDefault_StatemenetOfExpenses", Data.CustomerAccount, Data.UserId)); return(results); } catch (Exception ex) { throw ex; } }
public Dictionary <string, object> ChangePasswordForNewUser(ChangePasswordJson Data) { FAMSEntities context = new FAMSEntities(); try { //var results = Common.Getdata(context.MultipleResults("[dbo].[sp_UserLogin]").With<CommonFields>().Execute("@Querytype", "@OldPassword", "@ChangePassword", "@UserId", "ChangePassWordNewUser", Data.OldPassword, Data.NewPassword, Dbsecurity.Decrypt(HttpContext.Current.Server.UrlDecode(Data.UserId.Replace("_", "%"))))); var results = Common.Getdata(context.MultipleResults("[dbo].[sp_UserLogin]").With <CommonFields>().Execute("@Querytype", "@OldPassword", "@ChangePassword", "@UserId", "ChangePassWordNewUser", Data.OldPassword, Data.NewPassword, Dbsecurity.Decrypt(Data.UserId))); return(results); } catch (Exception ex) { throw ex; } }
public Dictionary <string, object> GetLinks(JsonLink Data) { FAMSEntities context = new FAMSEntities(); try { var results = Common.Getdata(context.MultipleResults("[dbo].[sp_linksetup]").With <LinkAllFields>() .Execute("@Querytype", "@UserType", "BindLinksUserWise", Data.UserType)); return(results); } catch (Exception ex) { throw ex; } }
public Dictionary <string, object> ReadPDF() { FAMSEntities context = new FAMSEntities(); System.Data.DataTable dt1 = new System.Data.DataTable(); dt1.Columns.Add("Result", typeof(int)); var y = 0; try { HttpResponseMessage result = null; var httpRequest = HttpContext.Current.Request; if (httpRequest.Files.Count > 0) { HttpPostedFile file = httpRequest.Files[0]; Stream stream = file.InputStream; string FileName = Path.GetFileName(file.FileName); string Extension = Path.GetExtension(file.FileName); string FolderPath = HttpContext.Current.Server.MapPath("/FAMSIN"); string FilePath = FolderPath + '/' + FileName; if (!Directory.Exists(FolderPath)) // CHECK IF THE FOLDER EXISTS. IF NOT, CREATE A NEW FOLDER. { Directory.CreateDirectory(FolderPath); } if (File.Exists(FilePath)) { File.Delete(FilePath); } file.SaveAs(FilePath); } } catch (Exception ex) { //throw ex; dt1.Rows.Add(); dt1.Rows[y]["Result"] = -1; return(ClsJson.JsonMethods.ToJson(dt1)); } dt1.Rows.Add(); dt1.Rows[y]["Result"] = 1; return(ClsJson.JsonMethods.ToJson(dt1)); }