public ActionResult GetPaged(int PageNumber)
{
TempData.Keep();
ClientBoxesSearch obj = TempData["obj_ClientBoxesSearch"] as ClientBoxesSearch;
if (PageNumber == 0)
{
PageNumber = 1;
}
int start_index = (this.PAGE_SIZE * (PageNumber - 1) + 1);
List <SET_CLIENT_DEPT_BOXES_GET_Result> box_list = new List <SET_CLIENT_DEPT_BOXES_GET_Result>();
using (DBEntities db = new DBEntities()) {
box_list = db.SET_CLIENT_DEPT_BOXES_GET(obj.BOX_NO, obj.CLIENT_NO, obj.DEPT_NO, obj.PROD_TYPE_NO, obj.CLIENT_BOX_ID, obj.CHALLAN_NO, obj.TRN_TYPE_NO, obj.REQ_TYPE_NO, obj.TRANSMIT_NO, obj.IS_OLD_DATA, obj.RECALL_BOX_NO, start_index, this.PAGE_SIZE * PageNumber).ToList();
}
if (box_list == null)
{
box_list = new List <SET_CLIENT_DEPT_BOXES_GET_Result>();
}
ViewBag.PageNumber = PageNumber;
ViewBag.TotalRecords = TempData["box_TotalRecords"];
ViewBag.PAGE_SIZE = this.PAGE_SIZE;
return(View("List", box_list));
}
public ActionResult Search(ClientBoxesSearch obj)
{
ViewBag.PageNumber = 1;
TempData["obj_ClientBoxesSearch"] = obj;
List <SET_CLIENT_DEPT_BOXES_GET_Result> box_list = new List <SET_CLIENT_DEPT_BOXES_GET_Result>();
obj.TotalRecords = 0;
using (DBEntities db = new DBEntities()) {
ObjectParameter CNT_parameter = new ObjectParameter("CNT", obj.TotalRecords);
db.SET_CLIENT_DEPT_BOXES_GET_PAGED(CNT_parameter, obj.BOX_NO, obj.CLIENT_NO, obj.DEPT_NO, obj.PROD_TYPE_NO, obj.CLIENT_BOX_ID, obj.CHALLAN_NO, obj.TRN_TYPE_NO, obj.REQ_TYPE_NO, obj.TRANSMIT_NO, obj.IS_OLD_DATA, obj.RECALL_BOX_NO);
obj.TotalRecords = (long)CNT_parameter.Value;
box_list = db.SET_CLIENT_DEPT_BOXES_GET(obj.BOX_NO, obj.CLIENT_NO, obj.DEPT_NO, obj.PROD_TYPE_NO, obj.CLIENT_BOX_ID, obj.CHALLAN_NO, obj.TRN_TYPE_NO, obj.REQ_TYPE_NO, obj.TRANSMIT_NO, obj.IS_OLD_DATA, obj.RECALL_BOX_NO, obj.START_INDEX, this.PAGE_SIZE * obj.PAGE_NUMBER).ToList();
}
if (box_list == null)
{
box_list = new List <SET_CLIENT_DEPT_BOXES_GET_Result>();
}
ViewBag.TotalRecords = obj.TotalRecords;
ViewBag.PAGE_SIZE = this.PAGE_SIZE;
TempData["box_TotalRecords"] = obj.TotalRecords;
TempData.Keep();
return(View("List", box_list));
}
public JsonResult GetClientBox(ClientBoxesSearch item)
{
List <SET_CLIENT_DEPT_BOXES_GET_Result> box_list = new List <SET_CLIENT_DEPT_BOXES_GET_Result>();
using (DBEntities db = new DBEntities()) {
box_list = db.SET_CLIENT_DEPT_BOXES_GET(item.BOX_NO, item.CLIENT_NO, item.DEPT_NO, item.PROD_TYPE_NO, item.CLIENT_BOX_ID, item.CHALLAN_NO, item.TRN_TYPE_NO, item.REQ_TYPE_NO, item.TRANSMIT_NO, item.IS_OLD_DATA, item.RECALL_BOX_NO, item.START_INDEX, item.END_INDEX).ToList();
}
var ret_list = (from d in box_list
select new {
@BOX_NO = d.BOX_NO,
@CLIENT_BOX_ID = d.CLIENT_BOX_ID,
@ARCHIVE_DATE = Utility.GetDateString(d.ARCHIVE_DATE, "dd/MM/yyyy"),
@TRN_TYPE_NO = d.TRN_TYPE_NO,
@CLIENT_NO = d.CLIENT_NO,
@DEPT_NO = d.DEPT_NO,
@IS_OLD_DATA = d.IS_OLD_DATA,
}
);
return(Json(ret_list, JsonRequestBehavior.AllowGet));
}
public JsonResult GetRecallBoxIDByClientBoxId(ClientBoxesSearch item)
{
List <GET_RECALL_BOX_NO_BY_CLIENT_BOX_ID_Result> recall_box_no = new List <GET_RECALL_BOX_NO_BY_CLIENT_BOX_ID_Result>();
using (DBEntities db = new DBEntities())
{
recall_box_no = db.GET_RECALL_BOX_NO_BY_CLIENT_BOX_ID(item.CLIENT_BOX_ID, item.CLIENT_NO).ToList();
}
var ret_recall_box_no = (from d in recall_box_no
select new
{
@BOX_NO = d.BOX_NO,
@RECALL_BOX_NO = d.RECALL_BOX_NO,
@CLIENT_BOX_ID = d.CLIENT_BOX_ID,
@CLIENT_NO = d.CLIENT_NO,
@DEPT_NO = d.DEPT_NO,
@RECALL_BOX_ID = d.RECALL_BOX_ID,
}
);
return(Json(ret_recall_box_no, JsonRequestBehavior.AllowGet));
}
