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));
}
