public Dictionary <string, object> BindGrid(GridFields Data)
{
try
{
//var UserId = Dbsecurity.Decypt(Data.UserId);
//var CustomerAccountNo = Dbsecurity.Decrypt(Data.CustomerAccountNo);
var CustomerAccountNo = (Data.CustomerAccountNo);
// string base64 = "";
// var results = Common.Getdata(context.MultipleResults("[dbo].[Sp_CapitalStatement]").With<CapitalStatementModel>().Execute("@QueryType", "@Fromdate", "@Todate", "BindMainGrid",fromdate,todate));
//var results = Common.Getdata(context.MultipleResults("[dbo].[Sp_StatementDividend]").With<StatementDividentModel>().With<DividendModel>().With<SDSum>().With<SumDividend>().With<HDATE>().Execute("@QueryType", "@PageCount", "@Fromdate", "@Todate", "@CustomerAccount", "BindMainGrid", Data.PageCount, Data.fromdate, Data.todate, CustomerAccountNo));
var results = Common.Getdata(context.MultipleResults("[dbo].[Sp_StatementDividend]").With <StatementDividentModel>().With <SDSum>().With <HDATE>().Execute("@QueryType", "@PageCount", "@Fromdate", "@Todate", "@CustomerAccount", "BindMainGrid", Data.PageCount, Data.fromdate, Data.todate, CustomerAccountNo));
// MemoryStream MyMemoryStream = new MemoryStream();
//Root.Reports.Report report = new Root.Reports.Report(new PdfFormatter());
//FontDef fd = new FontDef(report, "Helvetica");
//FontProp fp = new FontPropMM(fd, 25);
//Page page = new Page(report);
//page.AddCB_MM(80, new RepString(fp, "Hello World!"));
//RT.ViewPDF(report, "HelloWorld.pdf");
// base64 = Convert.ToBase64String(MyMemoryStream.ToArray());
return(results); //
}
catch (Exception ex)
{
throw ex;
}
}
public Dictionary <string, object> SaveAutoReportRequest(string EData)
{
DataTable dts = (DataTable)JsonConvert.DeserializeObject(EData, (typeof(DataTable)));
string Insert_MandateID_BulkSMS_xml = GetXmlByDatable(dts);
//DataTable dt = CommonManger.FillDatatableWithParam("Sp_SendEmail", "@QueryType", "@Insert_MandateID_BulkSMS_xml", "@Activity", "Insert_MandateID_BulkSMS", Insert_MandateID_BulkSMS_xml, ActivityID);
var Result = Common.Getdata(dbcontext.MultipleResults("[dbo].[FAMS_AutoReportRequest]").With <Result>().Execute("@QueryType", "@Insert_MandateID_BulkSMS_xml", "SaveAutoReportRequest", Insert_MandateID_BulkSMS_xml));
return(Result);
}
//public Dictionary<string, object> BindCountry()
//{
// try
// {
// var Result = Common.Getdata(context.MultipleResults("[dbo].[FAMS_TBStructure]").With<Country>().Execute("@QueryType", "BindCountry"));
// return Result;
// }
// catch (Exception ex)
// {
// throw ex;
// }
//}
//public Dictionary<string, object> GetAllCustodian()
//{
// try
// {
// var Result = Common.Getdata(context.MultipleResults("[dbo].[FAMS_TBStructure]").With<Custodian>().Execute("@QueryType", "BindCustodian"));
// return Result;
// }
// catch (Exception ex)
// {
// throw ex;
// }
//}
public Dictionary <string, object> GetAllParent()
{
try
{
var Result = Common.Getdata(context.MultipleResults("[dbo].[FAMS_TBStructure]").With <Parent>().Execute("@QueryType", "BindParent"));
return(Result);
}
catch (Exception ex)
{
throw ex;
}
}
public Dictionary <string, object> BindGrid(CommonFields Data)
{
try
{
var results = Common.Getdata(context.MultipleResults("[dbo].[Sp_BrokerMaster]").With <BindAllFields>().With <BindAllFields2>().Execute("@QueryType", "@UserId", "BindGrid", Dbsecurity.Decrypt(HttpContext.Current.Server.UrlDecode(Data.UserId.Replace("_", "%")))));
return(results);
}
catch (Exception ex)
{
throw ex;
}
}
public Dictionary <string, object> BindSchemaMasterDetails(string SchemaMasterId)
{
try
{
var Result = Common.Getdata(context.MultipleResults("[dbo].[FAMS_SchemeMaster]").With <SchemaMaster>().Execute("@QueryType", "@SchemaMasterId", "BindSchemeMasterDetails", SchemaMasterId));
return(Result);
}
catch (Exception ex)
{
throw ex;
}
}
public Dictionary <string, object> BindPMSMaster()
{
try
{
var Result = Common.Getdata(context.MultipleResults("[dbo].[FAMS_PMS]").With <PMSMaster>().Execute("@QueryType", "BindPMS"));
return(Result);
}
catch (Exception ex)
{
throw ex;
}
}
public Dictionary <string, object> BindState(string CountryCode)
{
try
{
var Result = Common.Getdata(context.MultipleResults("[dbo].[FAMS_City]").With <City>().Execute("@QueryType", "@CountryCode", "BindState", CountryCode));
return(Result);
}
catch (Exception ex)
{
throw ex;
}
}
public Dictionary <string, object> GetData(string fromdate, string Todate, string CustomerAccount)
{
try
{
var results = Common.Getdata(context.MultipleResults("[dbo].[Sp_DemoReport]").With <SummaryReports>()
.Execute("@Querytype", "@CustomerAccount", "@Fromdate", "@Todate", "GetSummaryReportData", CustomerAccount, fromdate, Todate));
return(results);
}
catch (Exception ex)
{
throw ex;
}
}
public Dictionary <string, object> BindCountry()
{
try
{
var Result = Common.Getdata(context.MultipleResults("[dbo].[FAMS_SecurityDetails]").With <Country>().Execute("@QueryType", "BindCountry"));
return(Result);
}
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;
}
}
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> 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;
}
}
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> BindGrid(GridFields Data)
{
try
{
//var UserId = Dbsecurity.Decypt(Data.UserId); HDATE
//var CustomerAccountNo = Dbsecurity.Decrypt(Data.CustomerAccountNo);
var CustomerAccountNo = (Data.CustomerAccountNo);
// var results = Common.Getdata(context.MultipleResults("[dbo].[Sp_CapitalStatement]").With<CapitalStatementModel>().Execute("@QueryType", "@Fromdate", "@Todate", "BindMainGrid",fromdate,todate));
var results = Common.Getdata(context.MultipleResults("[dbo].[Sp_CapitalStatement]").With <CapitalStatementModel>().With <CSSum>().With <HDATE>().Execute("@QueryType", "@PageCount", "@Fromdate", "@Todate", "@CustomerAccount", "BindMainGrid", Data.PageCount, Data.fromdate, Data.todate, CustomerAccountNo));
return(results); //
}
catch (Exception ex)
{
throw ex;
}
}
protected void btnChangePassword_Click(object sender, EventArgs e)
{
try
{
if (txtPassword.Text == txtConfirmPassword.Text)
{
if (txtPassword.Text.Length >= 6)
{
ChangePassword = DbSecurity.Encrypt(txtPassword.Text, ref changePasswordKey);
//int Text = objManager.IntMethodWithParam("Sp_UserLogin", "@QueryType", "@ChangePassword", "@ChangePasswordKey",
// "@UserId", "UpdatePassword", ChangePassword, changePasswordKey, ViewState["UserId"].ToString());
var results = context.MultipleResults("[dbo].[Sp_UserLogin]").With <DefaultPasswordChange>().Execute("@QueryType", "@ChangePassword", "@ChangePasswordKey",
"@UserId", "UpdatePassword", ChangePassword, changePasswordKey, ViewState["UserId"].ToString());
foreach (var data in results)
{
dataList_value = data.Cast <DefaultPasswordChange>().ToList();
}
dt_value = ToDataTable(dataList_value);
if (Convert.ToInt32(dt_value.Rows[0]["value"]) >= 0)
{
HdnIndustries.Value = "Y";
//ScriptManager.RegisterStartupScript(this, typeof(Page), "msg", "alert('Password Updated Successfuly !!');window.location ='Login.aspx';", true);
//Response.Redirect("~/Login.aspx");
txtConfirmPassword.Text = "";
txtPassword.Text = "";
}
else
{
ScriptManager.RegisterStartupScript(this, typeof(Page), "msg", "alert('Password Updated Unsuccessfuly !!')", true);
}
}
else
{
ScriptManager.RegisterStartupScript(this, typeof(Page), "msg", "alert('Minimum Length Of Password Is 6 !!')", true);
txtConfirmPassword.Text = "";
txtPassword.Text = "";
// popup1.Visible = true;
}
}
else
{
ScriptManager.RegisterStartupScript(this, typeof(Page), "msg", "alert('New Password Does Not Match To Confirm Password !!')", true);
txtConfirmPassword.Text = "";
txtPassword.Text = "";
// popup1.Visible = true;
}
}
catch (Exception ex)
{
throw;
}
}
public Dictionary <string, object> BindAllTabs(CommonFields Data)
{
try
{
var results = Common.Getdata(context.MultipleResults("[dbo].[sp_linksetup]").With <BindAllTabs>().Execute("@QueryType", "@UserType", "BindAllTabs", Data.UserId));
return(results);
// , Dbsecurity.Decrypt(HttpContext.Current.Server.UrlDecode(Data.UserId.Replace("_", "%"))) "@UserId",
}
catch (Exception ex)
{
throw ex;
}
}
public Dictionary <string, object> GetData(string fromdate, string Todate, string customerid, string Firstlevel, string Secondlevel, string Thirdlevel, string Firstlevelid, string Secondlevelid, string Thirdlevelid)
{
try
{
var results = Common.Getdata(context.MultipleResults("[dbo].[BINDREPORTS]").With <GetReportData>()
.Execute("@fromdate", "@Todate", "@customerid", "@Firstlevel", "@Secondlevel", "@Thirdlevel", "@Firstlevelid", "@Secondlevelid", "@Thirdlevelid", fromdate, Todate, customerid, Firstlevel, Secondlevel, Thirdlevel, Firstlevelid, Secondlevelid, Thirdlevelid));
return(results);
}
catch (Exception ex)
{
throw ex;
}
}
public Dictionary <string, object> GetData(string fromdate, string Todate, string CustomerAccount, string Accounts, string AccountSubLayer)
{
try
{
var results = Common.Getdata(context.MultipleResults("[dbo].[Sp_TrialBalanceReport]").With <BindGridAllField>()
.Execute("@Querytype", "@CustomerAccount", "@Fromdate", "@Todate", "@Accounts", "@AccountSubLayer", "BindGride", CustomerAccount, fromdate, Todate, Accounts, AccountSubLayer));
return(results);
}
catch (Exception ex)
{
throw ex;
}
}
//List<SecurityDetails> dataList_SecurityDetails = new List<SecurityDetails>();
public Dictionary <string, object> BindCustodian()
{
try
{
var Result = Common.Getdata(context.MultipleResults("[dbo].[FAMS_PMSCustomerList]").With <Custodian>().Execute("@QueryType", "BindCustodian"));
return(Result);
}
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> 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> 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> 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> 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> 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> 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;
}
}
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> 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> 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;
}
}
