public static object SaveCustomExpens(CustomsInvoicesDetail scParam) { object data = new { }; CustomsInvoicesDetail item = new CustomsInvoicesDetail(); item.CustomsDetailsID = scParam.CustomsDetailsID; item.CustomsExpenseValue = scParam.CustomsExpenseValue; item.CustomsInvoiceID = scParam.CustomsInvoiceID; item.ExpenseTypeID = scParam.ExpenseTypeID; item.IsDeleted = false; item.CarsNo = scParam.CarsNo; item.TotalExpensesValue = scParam.TotalExpensesValue; bool status = new CustomsInvoicesManager().SaveDetailsItem(item); if ((item.ExpenseTypeID > 0 && item.CustomsExpenseValue > -1) || status) { HttpContext.Current.Cache.Remove("CustomsInvoicesDetails"); data = new { Status = true, Message = Resources.AdminResources_ar.SuccessSave }; } else { data = new { Status = false, Message = Resources.AdminResources_ar.ErrorSave } }; return(data); }
public static string GetCustomCompExpenses(string container) { var result = new CustomsInvoicesManager().GetCustomsExpenseTypesForComp(container); //return result.Expenses; var serializer = new JavaScriptSerializer(); string jsonString = serializer.Serialize(new { ExpenseTypes = result }); return(jsonString); }
public static void FillCustomsInvoiceProperties(DropDownList ddlCustomsCo, DropDownList ddlContainer) { var result = new CustomsInvoicesManager().GetCustomsInvoiceProperties(); if (result != null) { ddlCustomsCo.DataSource = result.CustomCompanies; ddlCustomsCo.DataValueField = "CustomsCompanyID"; ddlCustomsCo.DataTextField = "CustomsCompanyNameAr"; ddlCustomsCo.DataBind(); ddlCustomsCo.Items.Insert(0, ""); } }
public static object DeleteCustomsExpense(CustomsInvoicesDetail scParam) { object data = new { }; int status = new CustomsInvoicesManager().DeleteDetailsItem(scParam.CustomsDetailsID); if (status > 0) { HttpContext.Current.Cache.Remove("CustomsInvoicesDetails"); data = new { Status = true, Message = Resources.AdminResources_ar.SuccessDelete }; } else { data = new { Status = false, Message = Resources.AdminResources_ar.ErrorDelete } }; return(data); }
public static object SaveInvoice(CustomsInvoice scParam) { object data = new { }; var status = new CustomsInvoicesManager().SaveItem(scParam); if (status > 0) { data = new { Status = true, ID = status, Message = Resources.AdminResources_ar.SuccessSave }; } else { data = new { Status = false, ID = 0, Message = Resources.AdminResources_ar.ErrorSave } }; return(data); }
public static object GetCustomsExpensesDetails() { jQueryDataTableParamModel param = new jQueryDataTableParamModel(); HttpContext Context = HttpContext.Current; param.sEcho = String.IsNullOrEmpty(Context.Request["sEcho"]) ? 0 : Convert.ToInt32(Context.Request["sEcho"]); param.sSearch = String.IsNullOrEmpty(Context.Request["sSearch"]) ? "" : Context.Request["sSearch"]; param.iDisplayStart = String.IsNullOrEmpty(Context.Request["iDisplayStart"]) ? 0 : Convert.ToInt32(Context.Request["iDisplayStart"]); param.iDisplayLength = String.IsNullOrEmpty(Context.Request["iDisplayLength"]) ? 0 : Convert.ToInt32(Context.Request["iDisplayLength"]); var sortColumnIndex = Convert.ToInt32(Context.Request["iSortCol_0"]); var sortDirection = Context.Request["sSortDir_0"]; // asc or desc //var containnerNo = String.IsNullOrEmpty(Context.Request["containerNo"]) ? "" : string.Format(" AND ContainerNo='{0}' ", Context.Request["containerNo"]); List <CustomsInvoicesDetails_SelectRowResult> categoryList = new List <CustomsInvoicesDetails_SelectRowResult>(); IEnumerable <CustomsInvoicesDetails_SelectRowResult> filtereAuctions; categoryList = new CustomsInvoicesManager().GetCustomsInvoicesDetails(" AND IsDeleted=0 AND CustomsInvoiceID IS NULL "); // check for search param if (!String.IsNullOrEmpty(param.sSearch)) { filtereAuctions = categoryList.Where(c => c.ExpenseTypeNameAr.ToString().ToLower().Contains(param.sSearch.ToLower()) || c.CustomsExpenseValue.ToString().ToLower().Contains(param.sSearch.ToLower())); } else { filtereAuctions = categoryList; } // handle asc and desc operation Func <CustomsInvoicesDetails_SelectRowResult, string> orderingFunction = (c => sortColumnIndex == 1 ? c.ExpenseTypeNameAr : sortColumnIndex == 2 ? c.CustomsExpenseValue.ToString() : ""); if (sortDirection == "asc") { filtereAuctions = filtereAuctions.OrderBy(orderingFunction); } else { filtereAuctions = filtereAuctions.OrderByDescending(orderingFunction); } //paginate our result var result = filtereAuctions.Select(c => new { ExpenseTypeNameAr = c.ExpenseTypeNameAr, CustomsExpenseValue = c.CustomsExpenseValue, ExpenseTypeID = c.ExpenseTypeID, CustomsDetailsID = c.CustomsDetailsID, CarsNo = c.CarsNo, TotalExpensesValue = c.TotalExpensesValue }); // Our last var data = new { sEcho = param.sEcho, iTotalRecords = categoryList.Count(), iTotalDisplayRecords = filtereAuctions.Count(), aaData = result }; return(data); }