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