public ActionResult OrganizationUnitPlan_Save(List <OrganizationUnitPlan> data) { var db = new OrganizationUnitPlan_DAL(); var result = new SystemMessage(); foreach (var item in data) { item.Type = 0; item.CreatedBy = Global.CurrentUser.UserID; item.CreatedOn = DateTime.Now; item.CreatedOn = DateTime.Now; item.ModifiedBy = Global.CurrentUser.UserID; result = db.OrganizationUnitPlan_Save(item); } if (result.IsSuccess == true) { result.Message = AppRes.MS_Update_success; } else { result.Message = AppRes.MS_Update_error; } return(Content(JsonConvert.SerializeObject(new { result }))); }
//[Permission(TableID = (int)ETable.OrganizationUnitPlan, TypeAction = (int)EAction.Get)] //[WriteLog(Action = EAction.Get, LogStoreProcedure = "OrganizationUnit_GetALL")] public ActionResult OrganizationUnit_GetALL() { var db = new OrganizationUnitPlan_DAL(); var result = db.OrganizationUnit_GetALL(); return(Content(JsonConvert.SerializeObject(new { result, }))); }
public ActionResult OrganizationUnitPlan_Delete(int ID) { var db = new OrganizationUnitPlan_DAL(); var result = db.OrganizationUnitPlan_Delete(ID); if (result.IsSuccess == true) { result.Message = AppRes.MS_Update_success; } else { result.Message = AppRes.MS_Update_error; } return(Content(JsonConvert.SerializeObject(new { result }))); }
public ActionResult TableServerSideGetData(int pageIndex, int pageSize, string filter = "") { var db = new OrganizationUnitPlan_DAL(); ToTalMonth ToTalMonth = new ToTalMonth(); int total = 0; int Languagecode = Global.CurrentLanguage; var result = db.OrganizationUnitPlan_GetList(pageIndex, pageSize, filter, Languagecode, out total, out ToTalMonth); var lstTotal = new TableColumnsTotalModel(); lstTotal.Total1 = "15"; lstTotal.Total2 = "25"; lstTotal.Total3 = "35"; return(Content(JsonConvert.SerializeObject(new { employees = result, totalCount = total, lstTotal = lstTotal, ToTalMonth = ToTalMonth }))); }
public ActionResult OrganizationUnitPlanExportExcel(string filter = "") { DataTable dt = new DataTable("Grid"); if (filter.Contains("!!") == true) { filter = filter.Replace("!!", "%"); } dt.Columns.AddRange(new DataColumn[] { new DataColumn(AppRes.OrganizationUnit), new DataColumn(AppRes.Currency), new DataColumn(AppRes.Year), new DataColumn(AppRes.Promotion_Status), new DataColumn(AppRes.L1), new DataColumn(AppRes.L2), new DataColumn(AppRes.L3), new DataColumn(AppRes.L4), new DataColumn(AppRes.L5), new DataColumn(AppRes.L6), new DataColumn(AppRes.L7), new DataColumn(AppRes.L8), new DataColumn(AppRes.L9), new DataColumn(AppRes.L10), new DataColumn(AppRes.L11), new DataColumn(AppRes.L12), new DataColumn(AppRes.R_Total), }); dt.Columns[0].DataType = typeof(string); dt.Columns[1].DataType = typeof(string); dt.Columns[2].DataType = typeof(string); dt.Columns[3].DataType = typeof(string); dt.Columns[4].DataType = typeof(double); dt.Columns[5].DataType = typeof(double); dt.Columns[6].DataType = typeof(double); dt.Columns[7].DataType = typeof(double); dt.Columns[8].DataType = typeof(double); dt.Columns[9].DataType = typeof(double); dt.Columns[10].DataType = typeof(double); dt.Columns[11].DataType = typeof(double); dt.Columns[12].DataType = typeof(double); dt.Columns[13].DataType = typeof(double); dt.Columns[14].DataType = typeof(double); dt.Columns[15].DataType = typeof(double); dt.Columns[16].DataType = typeof(double); var db = new OrganizationUnitPlan_DAL(); ToTalMonth ToTalMonth = new ToTalMonth(); int total = 0; int LanguageCode = Global.CurrentUser.CurrentLanguageID; var lstData = db.OrganizationUnitPlan_GetList(1, 10000, filter, LanguageCode, out total, out ToTalMonth); foreach (var item in lstData) { dt.Rows.Add(item.OrganizationUnitName, item.CurrencyName, item.Year, item.StatusName, item.M1, item.M2, item.M3, item.M4, item.M5, item.M6, item.M7, item.M8, item.M9, item.M10, item.M11, item.M12, item.SumValue); } 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", "OrganizationUnitPlan.xlsx")); }