public Models.BookWiseStockreportCircle get_dropdown() { BookWiseStockreportCircle lst_req = new BookWiseStockreportCircle(); List <Circle> lst_req1 = new List <Circle>(); try { DataTable dtMastData = objDbTrx.GetCircleMasterDetails(); if (dtMastData.Rows.Count > 0) { for (int iCnt = 0; iCnt < dtMastData.Rows.Count; iCnt++) { Circle rq = new Circle(); rq.CircleID = Convert.ToInt32(dtMastData.Rows[iCnt]["ID"].ToString()); rq.Circle_name = Convert.ToString(dtMastData.Rows[iCnt]["CIRCLE_NAME"].ToString()); lst_req1.Add(rq); } dtMastData.Dispose(); } lst_req.circle_collection = lst_req1; } catch (Exception ex) { throw new Exception(ex.Message); } return(lst_req); }
public ActionResult Index(BookWiseStockreportCircle objcust) { BookWiseStockreportCircle result = new BookWiseStockreportCircle(); if (ModelState.IsValid) { result = get_report(objcust.CircleID); } return(View(result)); }
public Models.BookWiseStockreportCircle get_report() { BookWiseStockreportCircle lst_req = new BookWiseStockreportCircle(); List <BookWiseStockreportCircle> lst_req1 = new List <BookWiseStockreportCircle>(); try { //DataTable dtMastData = objDbTrx.GetBookWiseReqStokDetails(Convert.ToInt64(GlobalSettings.oUserData.CircleID)); DataTable dtMastData = objDbTrx.GetBookWiseReqStokDetails(Convert.ToInt64(GlobalSettings.oUserData.CircleID)); //dtMastData = dtMastData.AsEnumerable() if (dtMastData.Rows.Count > 0) { for (int i = 0; i < dtMastData.Rows.Count; i++) { BookWiseStockreportCircle rq = new BookWiseStockreportCircle(); rq.language = Convert.ToString(dtMastData.Rows[i]["language"].ToString()); //rq.Category = Convert.ToString(dtMastData.Rows[i]["BOOK_CATEGORY"].ToString()); rq.BookName = Convert.ToString(dtMastData.Rows[i]["book_name"].ToString()); rq.stock_quantity = "0"; rq.stock_damage_quantity = "0"; if (dtMastData.Rows[i]["stock_total"].ToString().Trim() != "") { rq.stock_quantity = Convert.ToString(dtMastData.Rows[i]["stock_total"].ToString()); } rq.stock_damage_quantity = "0"; if (dtMastData.Rows[i]["stock_damage"].ToString().Trim() != "") { rq.stock_damage_quantity = Convert.ToString(dtMastData.Rows[i]["stock_damage"].ToString()); } rq.req_quantity = "0"; if (dtMastData.Rows[i]["total"].ToString().Trim() != "") { rq.req_quantity = Convert.ToString(dtMastData.Rows[i]["total"].ToString()); } rq.BookCode = Convert.ToString(dtMastData.Rows[i]["book_code"].ToString()); rq.remaining_quantity = Convert.ToString((Convert.ToInt32(rq.req_quantity) - Convert.ToInt32(rq.stock_quantity)) >= default(int) ? (Convert.ToInt32(rq.req_quantity) - Convert.ToInt32(rq.stock_quantity)) : default(int)); rq.QtyRcvdAtCircle = Convert.ToString(dtMastData.Rows[i]["QtyRcvd"].ToString()); rq.QtyDlvToSchool = Convert.ToString(dtMastData.Rows[i]["QtyDlvSch"].ToString()); lst_req1.Add(rq); } } lst_req.bookwise_collection = lst_req1; } catch (Exception ex) { throw new Exception(ex.Message); } return(lst_req); }
public Models.BookWiseStockreportCircle get_report(int var) { BookWiseStockreportCircle lst_req = new BookWiseStockreportCircle(); SqlConnection con = null; List <BookWiseStockreportCircle> lst_req1 = new List <BookWiseStockreportCircle>(); try { DataTable dtMastData = objDbTrx.GetBookWiseReqStokDetails(Convert.ToInt64(var.ToString())); if (dtMastData.Rows.Count > 0) { for (int i = 0; i < dtMastData.Rows.Count; i++) { BookWiseStockreportCircle rq = new BookWiseStockreportCircle(); rq.language = Convert.ToString(dtMastData.Rows[i]["language"].ToString()); rq.Category = Convert.ToString(dtMastData.Rows[i]["BOOK_CATEGORY"].ToString()); rq.BookName = Convert.ToString(dtMastData.Rows[i]["book_name"].ToString()); rq.stock_quantity = "0"; if (dtMastData.Rows[i]["stock_total"].ToString().Trim() != "") { rq.stock_quantity = Convert.ToString(dtMastData.Rows[i]["stock_total"].ToString()); } rq.req_quantity = "0"; if (dtMastData.Rows[i]["total"].ToString().Trim() != "") { rq.req_quantity = Convert.ToString(dtMastData.Rows[i]["total"].ToString()); } rq.BookCode = Convert.ToString(dtMastData.Rows[i]["book_code"].ToString()); rq.remaining_quantity = Convert.ToString(Convert.ToInt32(rq.req_quantity) - Convert.ToInt32(rq.stock_quantity)); lst_req1.Add(rq); } } lst_req.bookwise_collection = lst_req1; } catch (Exception ex) { throw new Exception(ex.Message); } List <Circle> lst_req2 = new List <Circle>(); try { DataTable dtMastData = objDbTrx.GetCircleMasterDetails(); if (dtMastData.Rows.Count > 0) { for (int iCnt = 0; iCnt < dtMastData.Rows.Count; iCnt++) { Circle rq = new Circle(); rq.CircleID = Convert.ToInt32(dtMastData.Rows[iCnt]["ID"].ToString()); rq.Circle_name = Convert.ToString(dtMastData.Rows[iCnt]["CIRCLE_NAME"].ToString()); lst_req2.Add(rq); } dtMastData.Dispose(); } lst_req.circle_collection = lst_req2; lst_req.CircleID = var; } catch (Exception ex) { throw new Exception(ex.Message); } return(lst_req); }