public ActionResult Search(ChallanSearch obj)
{
ViewBag.PageNumber = 1;
TempData["obj_ChallanSearch"] = obj;
List <TRN_CHALLANS_GET_Result> challan_list = new List <TRN_CHALLANS_GET_Result>();
obj.TotalRecords = 0;
using (DBEntities db = new DBEntities()) {
ObjectParameter CNT_parameter = new ObjectParameter("CNT", obj.TotalRecords);
//obj.TotalRecords = (int) db.TRN_CHALLANS_GET_PAGED(obj.CHALLAN_NO, obj.CLIENT_NO, obj.DEPT_NO, obj.CHALLAN_ID, obj.TRN_TYPE_NO, obj.REQ_TYPE_NO, obj.TRANSMIT_NO, obj.IS_OLD_DATA).FirstOrDefault().Value;
db.TRN_CHALLANS_GET_PAGED(CNT_parameter, obj.CHALLAN_NO, obj.CLIENT_NO, obj.DEPT_NO, obj.CHALLAN_ID, obj.TRN_TYPE_NO, obj.REQ_TYPE_NO, obj.TRANSMIT_NO, obj.IS_OLD_DATA);
obj.TotalRecords = (long)CNT_parameter.Value;
challan_list = db.TRN_CHALLANS_GET(obj.CHALLAN_NO, obj.CLIENT_NO, obj.DEPT_NO, obj.CHALLAN_ID, obj.TRN_TYPE_NO, obj.REQ_TYPE_NO, obj.TRANSMIT_NO, obj.IS_OLD_DATA, obj.START_INDEX, this.PAGE_SIZE * obj.PAGE_NUMBER).ToList();
}
if (challan_list == null)
{
challan_list = new List <TRN_CHALLANS_GET_Result>();
}
ViewBag.TotalRecords = obj.TotalRecords;
ViewBag.PAGE_SIZE = this.PAGE_SIZE;
TempData["challan_TotalRecords"] = obj.TotalRecords;
TempData.Keep();
return(View("List", challan_list));
}
public ActionResult GetPaged(int PageNumber)
{
TempData.Keep();
ChallanSearch obj = TempData["obj_ChallanSearch"] as ChallanSearch;
if (PageNumber == 0)
{
PageNumber = 1;
}
int start_index = (this.PAGE_SIZE * (PageNumber - 1) + 1);
List <TRN_CHALLANS_GET_Result> challan_list = new List <TRN_CHALLANS_GET_Result>();
using (DBEntities db = new DBEntities()) {
challan_list = db.TRN_CHALLANS_GET(obj.CHALLAN_NO, obj.CLIENT_NO, obj.DEPT_NO, obj.CHALLAN_ID, obj.TRN_TYPE_NO, obj.REQ_TYPE_NO, obj.TRANSMIT_NO, obj.IS_OLD_DATA, start_index, this.PAGE_SIZE * PageNumber).ToList();
}
if (challan_list == null)
{
challan_list = new List <TRN_CHALLANS_GET_Result>();
}
/*
* if (((challan_list.Count == 0) && (PageNumber > 0)) || (challan_list.Count < this.PAGE_SIZE)) {
* PageNumber--;
* if (PageNumber <= 0) {
* PageNumber = 1;
* }
* }
*/
ViewBag.PageNumber = PageNumber;
ViewBag.TotalRecords = TempData["challan_TotalRecords"];
ViewBag.PAGE_SIZE = this.PAGE_SIZE;
return(View("List", challan_list));
}
public JsonResult GetChallan(ChallanSearch item)
{
List <TRN_CHALLANS_GET_Result> challan_list = new List <TRN_CHALLANS_GET_Result>();
using (DBEntities db = new DBEntities()) {
challan_list = db.TRN_CHALLANS_GET(item.CHALLAN_NO, item.CLIENT_NO, item.DEPT_NO, item.CHALLAN_ID, item.TRN_TYPE_NO, item.REQ_TYPE_NO, item.TRANSMIT_NO, item.IS_OLD_DATA, item.START_INDEX, item.END_INDEX).ToList();
}
var ret_challan_list = (from d in challan_list
select new {
@CHALLAN_NO = d.CHALLAN_NO,
@CHALLAN_ID = d.CHALLAN_ID,
@REC_DATE = Utility.GetDateString(d.REC_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_challan_list, JsonRequestBehavior.AllowGet));
}
