public ActionResult CreateChallan() { SchoolChallan ObjReq = new SchoolChallan(); try { Int64 ReqId = Convert.ToInt64(TempData["ID"].ToString()); Int64 challanId = Convert.ToInt64(TempData["SchChallanId"].ToString()); ObjReq.SchoolChallanUniqueId = challanId; DataTable dtReqView = objDbTrx.GetRequisitionDtlByReqId(ReqId, challanId); if (dtReqView.Rows.Count > 0) { ObjReq.SchoolChallanDate = DateTime.Now.ToString("dd-MMM-yyyy"); //ObjReq.SchoolChallanCode = "SCH" + (DateTime.Now.Month >= 4 ? DateTime.Now.Year.ToString().Substring(2) + "-" + (Convert.ToInt32(DateTime.Now.Year.ToString().Substring(2)) + 1) + "-XXXXXXX" : (Convert.ToInt32(DateTime.Now.Year.ToString().Substring(2)) - 1) + "-" + DateTime.Now.Year.ToString().Substring(2) + "-XXXXXXX").ToString(); ObjReq.SchoolChallanCode = string.Format("{0}{1}", GlobalSettings.oAcademicYear.PFX_SCHCHALLAN, new String('X', GlobalSettings.oAcademicYear.FormatNumberPaddingCount)); ObjReq.RequisitionId = Convert.ToInt64(dtReqView.Rows[0]["REQUISITION_ID"].ToString()); ObjReq.RequisitionDate = Convert.ToDateTime(dtReqView.Rows[0]["REQUISITION_DATE"].ToString()).ToString("dd-MMM-yyyy hh:mm tt").ToUpper(); ObjReq.ReqCode = Convert.ToString(dtReqView.Rows[0]["REQ_CODE"].ToString()); ObjReq.SchoolName = Convert.ToString(dtReqView.Rows[0]["SCHOOL_NAME"].ToString()); ObjReq.SchoolCode = Convert.ToString(dtReqView.Rows[0]["SCHOOL_CODE"].ToString()); ObjReq.SchoolAddress = Convert.ToString(dtReqView.Rows[0]["SCHOOL_ADDRESS"].ToString()); ObjReq.SchoolContactNo = Convert.ToString(dtReqView.Rows[0]["SCHOOL_PHONE_NO"].ToString()); ObjReq.Language = Convert.ToString(dtReqView.Rows[0]["LANGUAGE"].ToString()); ObjReq.Category = Convert.ToString(dtReqView.Rows[0]["BOOK_CATEGORY"].ToString()); if (dtReqView.Rows[0]["SCH_CHALLAN_CODE"].ToString() != "") { ObjReq.SchoolChallanCode = Convert.ToString(dtReqView.Rows[0]["SCH_CHALLAN_CODE"].ToString()); ObjReq.SchoolChallanDate = Convert.ToDateTime(dtReqView.Rows[0]["SCH_CHALLAN_DATE"].ToString()).ToString("dd-MMM-yyyy"); } List <SchoolChallanBookReqDtl> ObjlstChallan = new List <SchoolChallanBookReqDtl>(); for (int iCnt = 0; iCnt < dtReqView.Rows.Count; iCnt++) { // Remaining = 0; SchoolChallanBookReqDtl objChDtl = new SchoolChallanBookReqDtl(); objChDtl.ReqDtlId = Convert.ToInt64(dtReqView.Rows[iCnt]["REQUISITION_DTL_ID"].ToString()); objChDtl.BookID = Convert.ToInt64(dtReqView.Rows[iCnt]["BOOK_ID"].ToString()); objChDtl.BookCode = dtReqView.Rows[iCnt]["BOOK_CODE"].ToString(); objChDtl.BookName = dtReqView.Rows[iCnt]["BOOK_NAME"].ToString(); objChDtl.Class = dtReqView.Rows[iCnt]["CLASS"].ToString(); objChDtl.RequisitionQuantity = Convert.ToInt64(dtReqView.Rows[iCnt]["REQ_QTY"].ToString()); //06-12-2018 -- Changeed by Anik Sen objChDtl.AvailableStockQuantity = (Convert.ToInt64(dtReqView.Rows[iCnt]["QTY_RECEIVED"].ToString()) + Convert.ToInt64(dtReqView.Rows[iCnt]["STOCK_QTY"].ToString())) - Convert.ToInt64(dtReqView.Rows[iCnt]["ALREADY_SHIPPED"].ToString()); objChDtl.AvailableStockQuantity = objChDtl.AvailableStockQuantity > default(long) ? objChDtl.AvailableStockQuantity : default(long); objChDtl.AlreadyShippedQuantity = Convert.ToInt64(dtReqView.Rows[iCnt]["ALREADY_SHIPPED"].ToString()); objChDtl.QuantityForShipping = Convert.ToInt64(dtReqView.Rows[iCnt]["QTY_FOR_SHIPPING"].ToString()); objChDtl.QtyReceived = Convert.ToInt64(dtReqView.Rows[iCnt]["QTY_RECEIVED"].ToString()); objChDtl.StockQty = Convert.ToInt64(dtReqView.Rows[iCnt]["STOCK_QTY"].ToString()); ObjlstChallan.Add(objChDtl); } ObjReq.trxSchoolChallanBookReqDtl = ObjlstChallan; } } catch (Exception ex) { objDbTrx.SaveSystemErrorLog(ex, Request.UserHostAddress); } return(View(ObjReq)); }
public Models.SchoolChallan getData(string SchChallanId) { SchoolChallan ObjReq = new SchoolChallan(); try { Int64 challanId = Convert.ToInt64(SchChallanId); ObjReq.SchoolChallanUniqueId = challanId; DataTable dtReqView = objDbTrx.GetSchoolChallanPrintDtl(challanId); if (dtReqView.Rows.Count > 0) { ObjReq.SchoolChallanCode = Convert.ToString(dtReqView.Rows[0]["SCH_CHALLAN_CODE"].ToString()); ObjReq.SchoolChallanDate = Convert.ToDateTime(dtReqView.Rows[0]["SCH_CHALLAN_DATE"].ToString()).ToString("dd-MMM-yyyy"); ObjReq.ChallanYear = (Convert.ToDateTime(ObjReq.SchoolChallanDate).Month >= 4 ? (Convert.ToInt32(Convert.ToDateTime(ObjReq.SchoolChallanDate).Year.ToString()) + 1).ToString() : (Convert.ToDateTime(ObjReq.SchoolChallanDate).Year.ToString()).ToString()); ObjReq.SchoolName = Convert.ToString(dtReqView.Rows[0]["SCHOOL_NAME"].ToString()); ObjReq.SchoolCode = Convert.ToString(dtReqView.Rows[0]["SCHOOL_CODE"].ToString()); ObjReq.SchoolAddress = Convert.ToString(dtReqView.Rows[0]["SCHOOL_ADDRESS"].ToString()); ObjReq.SchoolContactNo = Convert.ToString(dtReqView.Rows[0]["SCHOOL_PHONE_NO"].ToString()); ObjReq.SchoolEmailId = Convert.ToString(dtReqView.Rows[0]["SCHOOL_EMAIL_ID"].ToString()); ObjReq.Language = Convert.ToString(dtReqView.Rows[0]["LANGUAGE"].ToString()); ObjReq.Category = Convert.ToString(dtReqView.Rows[0]["BOOK_CATEGORY"].ToString()); ObjReq.CIRCLE_OFFICER_NAME = Convert.ToString(dtReqView.Rows[0]["CIRCLE_OFFICER_NAME"].ToString()); ObjReq.CIRCLE_NAME = Convert.ToString(dtReqView.Rows[0]["CIRCLE_NAME"].ToString()); ObjReq.CIRCLE_ADDRESS = Convert.ToString(dtReqView.Rows[0]["CIRCLE_ADDRESS"].ToString()); ObjReq.CIRCLE_PINCODE = Convert.ToString(dtReqView.Rows[0]["CIRCLE_PINCODE"].ToString()); ObjReq.DISTRICT = Convert.ToString(dtReqView.Rows[0]["DISTRICT"].ToString()); ObjReq.MOBILE_NO = Convert.ToString(dtReqView.Rows[0]["MOBILE_NO"].ToString()); ObjReq.ALTERNATE_MOBILE_NO = Convert.ToString(dtReqView.Rows[0]["ALTERNATE_MOBILE_NO"].ToString()); ObjReq.EMAIL_ID = Convert.ToString(dtReqView.Rows[0]["EMAIL_ID"].ToString()); ObjReq.BookRwCnt = dtReqView.Rows.Count; if (ObjReq.BookRwCnt > 12) { ObjReq.BookRwCnt = ((ObjReq.BookRwCnt) / 12); if (ObjReq.BookRwCnt > 0) { ObjReq.BookRwCnt++; } } else { ObjReq.BookRwCnt = 1; } List <SchoolChallanBookReqDtl> ObjlstChallan = new List <SchoolChallanBookReqDtl>(); for (int iCnt = 0; iCnt < dtReqView.Rows.Count; iCnt++) { SchoolChallanBookReqDtl objChDtl = new SchoolChallanBookReqDtl(); objChDtl.BookCode = dtReqView.Rows[iCnt]["BOOK_CODE"].ToString(); objChDtl.BookName = dtReqView.Rows[iCnt]["BOOK_NAME"].ToString(); objChDtl.Class = dtReqView.Rows[iCnt]["CLASS"].ToString(); objChDtl.QuantityForShipping = Convert.ToInt16(dtReqView.Rows[iCnt]["SHIPPING_QTY"].ToString()); ObjlstChallan.Add(objChDtl); } ObjReq.trxSchoolChallanBookReqDtl = ObjlstChallan; } } catch (Exception ex) { objDbTrx.SaveSystemErrorLog(ex, Request.UserHostAddress); } return(ObjReq); }