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