public ActionResult TableServerSideGetData(int pageIndex, int pageSize, string filter) { var db = new PaymentProductDAL(); int?total = 0; TableColumnsTotal totalColumns = new TableColumnsTotal(); var baseListParam = new BaseListParam() { FilterField = filter, OrderByField = "", UserType = Global.CurrentUser.RoleId, UserId = Global.CurrentUser.LoginUserId, DeptId = Global.CurrentUser.OrganizationUnitID, PageIndex = pageIndex, PageSize = pageSize, LanguageCode = Global.CurrentUser.CurrentLanguageID.ToString() }; var result = db.GetPaymentProduct(baseListParam, out total, out totalColumns); var lstTotal = new TableColumnsTotalModel(); lstTotal.Total1 = "15"; lstTotal.Total2 = "25"; lstTotal.Total3 = "35"; return(Content(JsonConvert.SerializeObject(new { employees = result, totalCount = total, lstTotal = totalColumns, roleid = baseListParam.UserType.ToString() }))); }
public ActionResult SavePaymentProduct(PaymentProduct obj) { var baseListParam = new BaseListParam() { UserType = Global.CurrentUser.RoleId, UserId = Global.CurrentUser.LoginUserId, DeptId = Global.CurrentUser.OrganizationUnitID, LanguageCode = Global.CurrentUser.CurrentLanguageID.ToString() }; var db = new PaymentProductDAL(); var result = db.SavePaymentProduct(baseListParam, obj); //if (result.IsSuccess == true && obj.WPID == 0) //{ // result.Message = AppRes.MSG_INSERT_SUCCESSFUL; //} //else if (result.IsSuccess == true && obj.WPID != 0) //{ // result.Message = AppRes.MS_Update_success; //} return(Content(JsonConvert.SerializeObject(new { result }))); }
public ActionResult GetsBD() { var db = new PaymentProductDAL(); var result = db.StaffWhereRoleBD(); return(Content(JsonConvert.SerializeObject(new { result }))); }
public ActionResult GetEditItemById(int id, int CustomerID) { var baseListParam = new BaseListParam() { UserType = Global.CurrentUser.RoleId, UserId = Global.CurrentUser.LoginUserId, DeptId = Global.CurrentUser.OrganizationUnitID, LanguageCode = Global.CurrentUser.CurrentLanguageID.ToString() }; var db = new PaymentProductDAL(); var result = db.GetPaymentProductById(baseListParam, id, CustomerID); return(Content(JsonConvert.SerializeObject(new { result }))); }
public ActionResult PaymentProductExportExcel(int pageIndex, int pageSize, ListFilterParam list, string filter = "") { DataTable dt = new DataTable("Grid"); dt.Columns.AddRange(new DataColumn[9] { new DataColumn(AppRes.CustomerCode), new DataColumn(AppRes.Email), new DataColumn(AppRes.Website), new DataColumn(AppRes.BD), new DataColumn(AppRes.OrganizationUnitName), new DataColumn(AppRes.Product), new DataColumn(AppRes.Margin), new DataColumn(AppRes.PaymentDate), new DataColumn(AppRes.StatusName) }); dt.Columns[0].DataType = typeof(int); dt.Columns[1].DataType = typeof(string); dt.Columns[2].DataType = typeof(string); dt.Columns[3].DataType = typeof(string); dt.Columns[4].DataType = typeof(string); dt.Columns[5].DataType = typeof(string); dt.Columns[6].DataType = typeof(double); dt.Columns[7].DataType = typeof(DateTime); dt.Columns[8].DataType = typeof(string); var db = new PaymentProductDAL(); int?total = 0; var baseListParam = new BaseListParam() { FilterField = filter, OrderByField = "", UserType = Global.CurrentUser.RoleId, UserId = Global.CurrentUser.LoginUserId, DeptId = Global.CurrentUser.OrganizationUnitID, PageIndex = pageIndex, PageSize = int.MaxValue, LanguageCode = Global.CurrentUser.CurrentLanguageID.ToString() }; var lstData = db.ExportExcelPaymentProduct(baseListParam, list, out total); foreach (var item in lstData) { dt.Rows.Add( item.CustomerID, item.Email == null ? "" : item.Email, item.Website == null ? "" : item.Website, item.BDName == null ? "" : item.BDName, item.OrganizationUnitName == null ? "": item.OrganizationUnitName, item.ProductName == null ? "" : item.ProductName, item.Amount, item.PaymentDate, item.StatusName == null ? "" : item.StatusName ); } var wb = new XLWorkbook(); wb.Worksheets.Add(dt); byte[] data = null; using (var stream = new MemoryStream()) { wb.SaveAs(stream); data = stream.ToArray(); } return(File(data, "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet", "PaymentProduct.xlsx")); }
public ActionResult PaymentReferExportExcel(int pageIndex, int pageSize, ListFilterParam list, string filter = "") { filter = filter.Replace("!!", "%"); DateTime FromDateTypeDate = new DateTime(); DateTime ToDateTypeDate = new DateTime(); list.FromDate = Convert.ToDateTime(DateTime.ParseExact(list.StringFromDate, "dd-MM-yyyy HH:mm:ss", CultureInfo.InvariantCulture)); list.ToDate = Convert.ToDateTime(DateTime.ParseExact(list.StringToDate, "dd-MM-yyyy HH:mm:ss", CultureInfo.InvariantCulture)); DataTable dt = new DataTable("Grid"); dt.Columns.AddRange(new DataColumn[8] { new DataColumn(AppRes.CustomerCode), new DataColumn(AppRes.Email), new DataColumn(AppRes.ContractCode), new DataColumn(AppRes.PaymentDate), new DataColumn(AppRes.BD), new DataColumn(AppRes.OrganizationUnitName), new DataColumn(AppRes.Amount), new DataColumn(AppRes.AccountConverted) }); dt.Columns[0].DataType = typeof(string); dt.Columns[1].DataType = typeof(string); dt.Columns[2].DataType = typeof(string); dt.Columns[3].DataType = typeof(DateTime); dt.Columns[4].DataType = typeof(string); dt.Columns[5].DataType = typeof(string); dt.Columns[6].DataType = typeof(double); dt.Columns[7].DataType = typeof(double); var db = new PaymentProductDAL(); int?total = 0; var baseListParam = new BaseListParam() { FilterField = filter, OrderByField = "", UserType = Global.CurrentUser.RoleId, UserId = Global.CurrentUser.LoginUserId, DeptId = Global.CurrentUser.OrganizationUnitID, PageIndex = pageIndex, PageSize = int.MaxValue, LanguageCode = Global.CurrentUser.CurrentLanguageID.ToString() }; var lstData = db.ExportExcelPaymentRefer(baseListParam, list, out total); foreach (var item in lstData) { dt.Rows.Add( item.CustomerCode, item.Email, item.ContractCode == null ? "" : item.ContractCode, item.PaymentDate, item.BD == null ? "" : item.BD, item.OrganizationUnitName == null ? "" : item.OrganizationUnitName, item.Amount, item.AccountConversion ); } var wb = new XLWorkbook(); wb.Worksheets.Add(dt); byte[] data = null; using (var stream = new MemoryStream()) { wb.SaveAs(stream); data = stream.ToArray(); } return(File(data, "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet", "ReportsMarginRefer.xlsx")); }