public FileResult GDBNBdtlExportToExcel()
{
List <InvoiceCumChallan> objGDBNBdtl = new List <InvoiceCumChallan>();
string report_name = string.Empty;
try
{
DataTable dt = objDbTrx.GetGDBNBdtl();
if (dt.Rows.Count > 0)
{
for (int iCnt = 0; iCnt < dt.Rows.Count; iCnt++)
{
try
{
InvoiceCumChallan gdbnbdtl = new InvoiceCumChallan();
//gdbnb.DistrictId = Convert.ToInt32(dt.Rows[iCnt]["DISTRICT_ID"].ToString());
//gdbnb.CircleId = Convert.ToInt32(dt.Rows[iCnt]["CircleId"].ToString());
gdbnbdtl.InvoiceCumChallanNo = Convert.ToString(dt.Rows[iCnt]["CHALLAN_NUMBER"].ToString());
gdbnbdtl.InvoiceCumChallanDate = Convert.ToString(dt.Rows[iCnt]["CHALLAN_DATE"].ToString());
gdbnbdtl.book_code = Convert.ToString(dt.Rows[iCnt]["book_code"].ToString());
gdbnbdtl.BOOK_NAME = Convert.ToString(dt.Rows[iCnt]["BOOK_NAME"].ToString());
gdbnbdtl.TotalAmount = Convert.ToInt32(dt.Rows[iCnt]["QtyShippedQty"].ToString());
gdbnbdtl.DistrictName = Convert.ToString(dt.Rows[iCnt]["DISTRICT"].ToString());
gdbnbdtl.CircleName = Convert.ToString(dt.Rows[iCnt]["CIRCLE_NAME"].ToString());
gdbnbdtl.Transporter = Convert.ToString(dt.Rows[iCnt]["Transport_Name"].ToString());
gdbnbdtl.CONSIGNEE_NO = Convert.ToString(dt.Rows[iCnt]["CONSIGNEE_NO"].ToString());
gdbnbdtl.VEHICLE_NO = Convert.ToString(dt.Rows[iCnt]["VEHICLE_NO"].ToString());
objGDBNBdtl.Add(gdbnbdtl);
}
catch
{
continue;
}
}
}
if (objGDBNBdtl != null && objGDBNBdtl.Count() > default(int))
{
report_name = DateTime.Now.ToString("yyyyMMddHHmmssffff") + ".xls";
ReportDocument rd = new ReportDocument();
rd.Load(Path.Combine(Server.MapPath("~/Reports"), "rptGDBNBdtl.rpt"));
rd.SetDataSource(objGDBNBdtl);
Response.Buffer = false;
Response.ClearContent();
Response.ClearHeaders();
Stream stream = rd.ExportToStream(CrystalDecisions.Shared.ExportFormatType.Excel);
stream.Seek(0, SeekOrigin.Begin);
return(File(stream, "application/octet", report_name));
}
}
catch (Exception ex)
{
objDbTrx.SaveSystemErrorLog(ex, Request.UserHostAddress);
}
return(null);
}
public JsonResult GetCircleAddressDetails(string CircleID)
{
InvoiceCumChallan lst_invCumChal = new InvoiceCumChallan();
try
{
//DataTable dt = objDbTrx.GetCircleMasterDetailsByCircleId(Convert.ToInt32(CircleID));
DataTable dt = objDbTrx.GetCircleMasterDetailsByCircleIdNew(Convert.ToInt32(CircleID));
if (dt.Rows.Count > 0)
{
lst_invCumChal.CircleAddress = Convert.ToString(dt.Rows[0]["CIRCLE_ADDRESS"]);
lst_invCumChal.CirclePinCode = Convert.ToString(dt.Rows[0]["CIRCLE_PINCODE"]);
lst_invCumChal.InspectorName = Convert.ToString(dt.Rows[0]["CIRCLE_OFFICER_NAME"]);
lst_invCumChal.InspectorPhoneNo = Convert.ToString(dt.Rows[0]["MOBILE_NO"]);
lst_invCumChal.InspectorEmailId = Convert.ToString(dt.Rows[0]["EMAIL_ID"]);
}
else
{
lst_invCumChal.CircleAddress = "";
lst_invCumChal.CirclePinCode = "";
lst_invCumChal.InspectorName = "";
lst_invCumChal.InspectorPhoneNo = "";
lst_invCumChal.InspectorEmailId = "";
}
}
catch (Exception ex)
{
objDbTrx.SaveSystemErrorLog(ex, Request.UserHostAddress);
}
return(Json(lst_invCumChal));
}
public ActionResult Index()
{
string CircleId = "-1";
try { CircleId = GlobalSettings.oUserData.CircleID; }
catch { CircleId = "-1"; }
InvoiceCumChallan objChallan = new InvoiceCumChallan();
objChallan.IsPendingRequire = true;
objChallan.CircleId = Convert.ToInt16(CircleId);
return(View(objChallan));
}
public ActionResult Index(InvoiceCumChallan objInvCumChal)
{
if (ModelState.IsValid)
{
//if (String.IsNullOrEmpty(objInvCumChal.CONSIGNEE_NO))
// objInvCumChal.CONSIGNEE_NO = "";
//if (String.IsNullOrEmpty(objInvCumChal.VEHICLE_NO))
// objInvCumChal.VEHICLE_NO = "";
if (string.IsNullOrWhiteSpace(objInvCumChal.CONSIGNEE_NO) || string.IsNullOrWhiteSpace(objInvCumChal.VEHICLE_NO))
{
TempData["AppMessage"] = "Vehicle or Consignee Number cannot be blank";
return(RedirectToAction("Index", "TrxProvisionalChallan"));
}
try
{
string ChallanNo = "";
var userId = Session["UserSec"] != null ? GlobalSettings.oUserData.UserId : string.Empty;
if (userId != "")
{
if (Convert.ToInt64(objInvCumChal.ChallanId) != 0)
{
objInvCumChal.UserId = GlobalSettings.oUserData.UserId;
objDbTrx.UpdateInProvisionalChallan(objInvCumChal);
TempData["AppMessage"] = "Challan updated successfully and the Challan code is " + objInvCumChal.InvoiceCumChallanNo;
}
else
{
objInvCumChal.AcadYearId = GlobalSettings.oUserData.AcademicYearId;
objInvCumChal.UserId = GlobalSettings.oUserData.UserId;
objDbTrx.InsertInProvisionalChallan(objInvCumChal, GlobalSettings.oAcademicYear.PFX_CHALLAN, GlobalSettings.oAcademicYear.FormatNumberPaddingCount, out ChallanNo);
TempData["AppMessage"] = "Challan created successfully and the Challan code is " + ChallanNo;
}
return(RedirectToAction("Index", "TrxProvisionalChallanView"));
}
else
{
RedirectToAction("Index", "SPLogin");
}
}
catch (Exception ex)
{
objDbTrx.SaveSystemErrorLog(ex, Request.UserHostAddress);
}
finally
{
}
}
return(RedirectToAction("Index", "TrxProvisionalChallanView"));
}
public ActionResult GetLiveBinderBookStatusOnScan(string binderAllotCode, string categoryId, bool isPartialViewRequest = true)
{
int catId = default(int);
InvoiceCumChallan objInv = new InvoiceCumChallan();
try
{
Int16 AccadYear = Convert.ToInt16(GlobalSettings.oUserData.AcademicYearId);
int.TryParse(categoryId, out catId);
DataTable dt = objDbTrx.GetLiveBinderBookStatusOnScan(binderAllotCode, catId, AccadYear);
if (dt.Rows.Count > default(int))
{
objInv.lstBinderDetailsByScan = new List <BinderDetailsByScan>();
for (int i = 0; i < dt.Rows.Count; i++)
{
BinderDetailsByScan obj = new BinderDetailsByScan();
obj.BINDER_ALLOT_ID = Convert.ToInt32(dt.Rows[i]["BINDER_ALLOT_ID"].ToString());
obj.BINDER_ID = Convert.ToInt32(dt.Rows[i]["BINDER_ID"].ToString());
obj.BinderName = dt.Rows[i]["BinderName"].ToString();
obj.Book_Code = dt.Rows[i]["Book_Code"].ToString();
obj.Common_Book_Code = dt.Rows[i]["Common_Book_Code"].ToString();
obj.Book_Name = dt.Rows[i]["Book_Name"].ToString();
obj.CategoryID = Convert.ToDouble(dt.Rows[i]["CATEGORY_ID"].ToString());
obj.Lot = Convert.ToInt32(dt.Rows[i]["Lot"].ToString());
obj.TotalQty = Convert.ToInt64(dt.Rows[i]["TotalQty"].ToString());
obj.ScannedQty = Convert.ToInt64(dt.Rows[i]["ScannedQty"].ToString());
obj.RemainingQty = Convert.ToInt64(dt.Rows[i]["RemainingQty"].ToString());
objInv.lstBinderDetailsByScan.Add(obj);
}
}
}
catch (Exception ex)
{
objDbTrx.SaveSystemErrorLog(ex, Request.UserHostAddress);
}
if (isPartialViewRequest)
{
return(PartialView("~/Views/InvoiceCumChallanReqList/_ReqBookDtl.cshtml", objInv));
}
else
{
return(Json(objInv, JsonRequestBehavior.AllowGet));
}
}
public JsonResult UpdateFinalChallanHeader(InvoiceCumChallan pData)
{
bool result = default(bool);
string msg = string.Empty;
try
{
pData.UserId = GlobalSettings.oUserData.UserId;
result = objDbTrx.UpdateFinalChallanHeaderNew(pData);
msg = result ? "Challan updated successfully" : "Update error detected";
}
catch (Exception ex)
{
msg = ex.Message;
objDbTrx.SaveSystemErrorLog(ex, Request.UserHostAddress);
}
return(Json(new { Success = (result ? 1 : 0), Message = msg }, JsonRequestBehavior.AllowGet));
}
public JsonResult ConfirmProvisionalChallan(string griddata)
{
string[] ChallanIds = griddata.TrimEnd(',').Split(',');
string ErrorMessage = "";
try
{
InvoiceCumChallan objInvoiceCumChallan = new InvoiceCumChallan();
objInvoiceCumChallan.UserId = GlobalSettings.oUserData.UserId;
objInvoiceCumChallan.Status = 1;
objDbTrx.ConfirmProvisionalChallan(objInvoiceCumChallan, griddata.TrimEnd(','));
ErrorMessage = ChallanIds.Count() + " Challan confirmed successfully.";
}
catch (Exception ex)
{
ErrorMessage = "Some Error occured while confirming Requisition. Please confirm system administrator";
objDbTrx.SaveSystemErrorLog(ex, Request.UserHostAddress);
}
return(Json(ErrorMessage));
}
public Models.InvoiceCumChallan get_Data()
{
InvoiceCumChallan lst_invCumChal = new InvoiceCumChallan();
try
{
lst_invCumChal.InvoiceCumChallanDate = DateTime.Now.ToString("dd-MMM-yyyy");
//lst_invCumChal.InvoiceCumChallanNo = "TBC" + (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();
lst_invCumChal.InvoiceCumChallanNo = string.Format("{0}{1}", GlobalSettings.oAcademicYear.PFX_CHALLAN, new String('X', GlobalSettings.oAcademicYear.FormatNumberPaddingCount));
lst_invCumChal.ChallanId = 0;
if (Convert.ToString(Session["ChallanId"]) != "")
{
lst_invCumChal.ChallanId = Convert.ToInt64(Session["ChallanId"]);
Session["ChallanId"] = "";
}
if (Convert.ToInt64(lst_invCumChal.ChallanId) != 0)
{
DataTable dtChallanDtl = objDbTrx.GetProvisionalChallanDetailsById(Convert.ToInt64(lst_invCumChal.ChallanId));
if (dtChallanDtl.Rows.Count > 0)
{
lst_invCumChal.InvoiceCumChallanNo = dtChallanDtl.Rows[0]["CHALLAN_NUMBER"].ToString();
lst_invCumChal.InvoiceCumChallanDate = Convert.ToDateTime(dtChallanDtl.Rows[0]["CHALLAN_DATE"].ToString()).ToString("dd-MMM-yyyy");
lst_invCumChal.CONSIGNEE_NO = dtChallanDtl.Rows[0]["CONSIGNEE_NO"].ToString();
lst_invCumChal.VEHICLE_NO = dtChallanDtl.Rows[0]["VEHICLE_NO"].ToString();
lst_invCumChal.TransporterID = Convert.ToInt16(dtChallanDtl.Rows[0]["TRANSPORTER_ID"].ToString());
lst_invCumChal.Status = Convert.ToInt16(dtChallanDtl.Rows[0]["STATUS"].ToString());
lst_invCumChal.DistrictId = Convert.ToInt32(dtChallanDtl.Rows[0]["DISTRICT_ID"].ToString());
lst_invCumChal.CircleId = Convert.ToInt32(dtChallanDtl.Rows[0]["CircleId"].ToString());
lst_invCumChal.CategoryId = Convert.ToInt32(dtChallanDtl.Rows[0]["CHALLAN_BOOK_CATEGORY_ID"].ToString());
lst_invCumChal.LanguageId = Convert.ToInt32(dtChallanDtl.Rows[0]["LANGUAGE_ID"].ToString());
lst_invCumChal.ManualChallanNo = dtChallanDtl.Rows[0]["ManualChallanNo"].ToString();
}
}
}
catch (Exception ex)
{
objDbTrx.SaveSystemErrorLog(ex, Request.UserHostAddress);
}
finally { }
return(lst_invCumChal);
}
public ActionResult Index(InvoiceCumChallan objInvCumChal)
{
if (ModelState.IsValid)
{
try
{
objInvCumChal.AY_ID = GlobalSettings.oUserData.AcademicYearId;
string ChallanNo = "";
if (Convert.ToString(Session["sp_user_name"]) != "")
{
if (Convert.ToInt64(objInvCumChal.ChallanId) != 0)
{
objInvCumChal.UserId = Convert.ToString(Session["sp_user_name"]);
objDbTrx.UpdateInChallan(objInvCumChal);
}
else
{
objInvCumChal.UserId = Convert.ToString(Session["sp_user_name"]);
objDbTrx.InsertInChallan(objInvCumChal, GlobalSettings.oAcademicYear.PFX_CHALLAN, GlobalSettings.oAcademicYear.FormatNumberPaddingCount, out ChallanNo);
}
return(RedirectToAction("Index", "InvoiceCumChallanReqList"));
}
else
{
RedirectToAction("Index", "SPLogin");
}
}
catch (Exception ex)
{
objDbTrx.SaveSystemErrorLog(ex, Request.UserHostAddress);
}
finally
{
}
}
return(RedirectToAction("Index", "InvoiceCumChallan"));
}
public JsonResult GetChallanViewData(string startDate, string endDate, string CircleID, string DistrictID)
{
List <InvoiceCumChallan> objChallanList = new List <InvoiceCumChallan>();
try
{
Int16 AccadYear = Convert.ToInt16(GlobalSettings.oUserData.AcademicYearId);
DataTable dt = objDbTrx.GetProvisionalChallanViewModified(startDate, endDate, CircleID, DistrictID, AccadYear);
if (dt.Rows.Count > 0)
{
for (int iCnt = 0; iCnt < dt.Rows.Count; iCnt++)
{
InvoiceCumChallan icc = new InvoiceCumChallan();
icc.ChallanId = Convert.ToInt64(dt.Rows[iCnt]["ID"].ToString());
icc.InvoiceCumChallanNo = Convert.ToString(dt.Rows[iCnt]["Challan_Number"].ToString());
icc.CircleId = Convert.ToInt32(dt.Rows[iCnt]["CircleId"].ToString());
icc.InvoiceCumChallanDate = Convert.ToDateTime(dt.Rows[iCnt]["Challan_Date"].ToString()).ToString("dd-MMM-yyyy");
icc.CircleName = Convert.ToString(dt.Rows[iCnt]["Circle_Name"].ToString());
icc.CategoryName = Convert.ToString(dt.Rows[iCnt]["CHALLAN_BOOK_CATEGORY"].ToString());
icc.DistrictName = dt.Rows[iCnt]["DISTRICT"].ToString();
icc.Language = Convert.ToString(dt.Rows[iCnt]["LANGUAGE"].ToString());
icc.Transporter = Convert.ToString(dt.Rows[iCnt]["Transport_Name"].ToString());
icc.CONSIGNEE_NO = Convert.ToString(dt.Rows[iCnt]["CONSIGNEE_NO"].ToString());
icc.VEHICLE_NO = Convert.ToString(dt.Rows[iCnt]["VEHICLE_NO"].ToString());
icc.Status = Convert.ToInt16(dt.Rows[iCnt]["STATUS"].ToString());
icc.UpdatedBy = Convert.ToString(dt.Rows[iCnt]["UPDATED_BY"].ToString());
icc.UpdatedTimeStamp = Convert.ToDateTime(dt.Rows[iCnt]["UPDATED_TS"].ToString()).ToString("dd-MMM-yyyy");
icc.IsInvoiceCreated = Convert.ToString(dt.Rows[iCnt]["IsInvoiceCreated"].ToString());
objChallanList.Add(icc);
}
}
}
catch (Exception ex)
{
objDbTrx.SaveSystemErrorLog(ex, Request.UserHostAddress);
}
return(Json(objChallanList));
}
public Models.InvoiceCumChallan getData(string ChallanId)
{
int manualQty = 1;
int.TryParse((ConfigurationManager.AppSettings["ManualQty"] != null ? ConfigurationManager.AppSettings["ManualQty"] : "25"), out manualQty);
InvoiceCumChallan objInvCumChallan = new InvoiceCumChallan();
DataTable dtChallanDtl = objDbTrx.GetChallanPrintDetailsById(Convert.ToInt64(ChallanId));
if (dtChallanDtl.Rows.Count > 0)
{
objInvCumChallan.InvoiceCumChallanNo = dtChallanDtl.Rows[0]["CHALLAN_NUMBER"].ToString();
objInvCumChallan.InvoiceCumChallanDate = Convert.ToDateTime(dtChallanDtl.Rows[0]["CHALLAN_DATE"]).ToString("dd-MMM-yyyy");
// objInvCumChallan.InvoiceCumChallanYear = Convert.ToDateTime(dtChallanDtl.Rows[0]["CHALLAN_DATE"]).ToString("yyyy");
objInvCumChallan.InvoiceCumChallanYear = (Convert.ToDateTime(dtChallanDtl.Rows[0]["CHALLAN_DATE"]).Month >= 4 ? (Convert.ToInt32(Convert.ToDateTime(dtChallanDtl.Rows[0]["CHALLAN_DATE"]).Year.ToString()) + 1).ToString() : (Convert.ToDateTime(dtChallanDtl.Rows[0]["CHALLAN_DATE"]).Year.ToString()).ToString());
objInvCumChallan.Transporter = dtChallanDtl.Rows[0]["Transport_Name"].ToString();
objInvCumChallan.Language = dtChallanDtl.Rows[0]["LANGUAGE"].ToString().ToUpper();
objInvCumChallan.CONSIGNEE_NO = dtChallanDtl.Rows[0]["CONSIGNEE_NO"].ToString();
objInvCumChallan.VEHICLE_NO = dtChallanDtl.Rows[0]["VEHICLE_NO"].ToString();
objInvCumChallan.DistrictName = dtChallanDtl.Rows[0]["DISTRICT"].ToString();
objInvCumChallan.CircleName = dtChallanDtl.Rows[0]["Circle_Name"].ToString();
objInvCumChallan.UserId = dtChallanDtl.Rows[0]["UPDATED_BY"].ToString();
objInvCumChallan.ManualChallanNo = dtChallanDtl.Rows[0]["ManualChallanNo"].ToString();
objInvCumChallan.BookRwCnt = dtChallanDtl.Rows.Count;
if (objInvCumChallan.BookRwCnt > 12)
{
objInvCumChallan.BookRwCnt = ((objInvCumChallan.BookRwCnt) / 12);
if (objInvCumChallan.BookRwCnt > 0)
{
objInvCumChallan.BookRwCnt++;
}
}
else
{
objInvCumChallan.BookRwCnt = 1;
}
DataTable lot = objDbTrx.GetlotfromchallanID(ChallanId);
var strlisst = new List <string>();
List <InvoiceCumChallanList> lst_InvCumChallan = new List <InvoiceCumChallanList>();
for (int iCnt = 0; iCnt < dtChallanDtl.Rows.Count; iCnt++)
{
InvoiceCumChallanList icc = new InvoiceCumChallanList();
icc.ClassName = Convert.ToString(dtChallanDtl.Rows[iCnt]["Class"].ToString());
icc.Book_Code = Convert.ToString(dtChallanDtl.Rows[iCnt]["Common_Book_Code"].ToString());
icc.Book_Name = Convert.ToString(dtChallanDtl.Rows[iCnt]["book_name"].ToString());
icc.QtyShipped = Convert.ToInt32(dtChallanDtl.Rows[iCnt]["QtyShippedQty"].ToString());
//foreach (DataRow row in lot.Rows)
//{
// if (row[0].ToString() == icc.Book_Code)
// {
// strlisst.Add("" + row[1] + " pack," + row[2] + " book(s)");
// ////7 cartoon 25 in each pack, 1 cartoon of (reminder) in 1 pack
// }
//}
//icc.Cartoon = string.Format("{0} in each pack", string.Join("; ", strlisst));
//strlisst.Clear();
icc.Cartoon = Convert.ToString((icc.QtyShipped / manualQty)) + " bundle, " + manualQty.ToString() + " book(s) in each bundle" + ((icc.QtyShipped % manualQty) > 0 ? "; " + Convert.ToString(icc.QtyShipped % manualQty) + " book(s) in 1 pack" : "");
//icc.Cartoon = dtChallanDtl.Rows[iCnt]["Cartoon"].ToString();
icc.Remarks = dtChallanDtl.Rows[iCnt]["Remarks"].ToString();
icc.Weight = icc.QtyShipped * Convert.ToInt32(dtChallanDtl.Rows[iCnt]["Book_Weight"]);
lst_InvCumChallan.Add(icc);
}
objInvCumChallan.TotalAmount = 0;
objInvCumChallan.InvoiceCumChallanCollection = lst_InvCumChallan;
DataTable dt = objDbTrx.GetCircleMasterDetailsByCircleId(Convert.ToInt32(dtChallanDtl.Rows[0]["CircleId"].ToString()));
if (dt.Rows.Count > 0)
{
objInvCumChallan.CircleAddress = Convert.ToString(dt.Rows[0]["CIRCLE_ADDRESS"]);
objInvCumChallan.CirclePinCode = Convert.ToString(dt.Rows[0]["CIRCLE_PINCODE"]);
objInvCumChallan.InspectorName = Convert.ToString(dt.Rows[0]["CIRCLE_OFFICER_NAME"]);
objInvCumChallan.InspectorPhoneNo = Convert.ToString(dt.Rows[0]["MOBILE_NO"]);
objInvCumChallan.InspectorEmailId = Convert.ToString(dt.Rows[0]["EMAIL_ID"]);
dt.Dispose();
}
objInvCumChallan.CustomerOrderNo = "";
dt = objDbTrx.GetCustomerOrderNoByLanguageAndChallanCatId(Convert.ToInt16(dtChallanDtl.Rows[0]["LANGUAGE_ID"].ToString()), Convert.ToInt16(dtChallanDtl.Rows[0]["CHALLAN_BOOK_CATEGORY_ID"].ToString()));
if (dt.Rows.Count > 0)
{
objInvCumChallan.CustomerOrderNo = Convert.ToString(dt.Rows[0]["CUST_ORDER"]);
dt.Dispose();
}
dtChallanDtl.Dispose();
}
return(objInvCumChallan);
}
public Models.InvoiceCumChallan getDataLecacy(string ChallanId)
{
InvoiceCumChallan objInvCumChallan = new InvoiceCumChallan();
DataTable dtChallanDtl = objDbTrx.GetChallanPrintDetailsById(Convert.ToInt64(ChallanId));
if (dtChallanDtl.Rows.Count > 0)
{
objInvCumChallan.InvoiceCumChallanNo = dtChallanDtl.Rows[0]["CHALLAN_NUMBER"].ToString();
objInvCumChallan.InvoiceCumChallanDate = Convert.ToDateTime(dtChallanDtl.Rows[0]["CHALLAN_DATE"]).ToString("dd-MMM-yyyy");
// objInvCumChallan.InvoiceCumChallanYear = Convert.ToDateTime(dtChallanDtl.Rows[0]["CHALLAN_DATE"]).ToString("yyyy");
objInvCumChallan.InvoiceCumChallanYear = (Convert.ToDateTime(dtChallanDtl.Rows[0]["CHALLAN_DATE"]).Month >= 4 ? (Convert.ToInt32(Convert.ToDateTime(dtChallanDtl.Rows[0]["CHALLAN_DATE"]).Year.ToString()) + 1).ToString() : (Convert.ToDateTime(dtChallanDtl.Rows[0]["CHALLAN_DATE"]).Year.ToString()).ToString());
objInvCumChallan.Transporter = dtChallanDtl.Rows[0]["Transport_Name"].ToString();
objInvCumChallan.Language = dtChallanDtl.Rows[0]["LANGUAGE"].ToString().ToUpper();
objInvCumChallan.CONSIGNEE_NO = dtChallanDtl.Rows[0]["CONSIGNEE_NO"].ToString();
objInvCumChallan.VEHICLE_NO = dtChallanDtl.Rows[0]["VEHICLE_NO"].ToString();
objInvCumChallan.DistrictName = dtChallanDtl.Rows[0]["DISTRICT"].ToString();
objInvCumChallan.CircleName = dtChallanDtl.Rows[0]["Circle_Name"].ToString();
objInvCumChallan.UserId = dtChallanDtl.Rows[0]["UPDATED_BY"].ToString();
objInvCumChallan.BookRwCnt = dtChallanDtl.Rows.Count;
if (objInvCumChallan.BookRwCnt > 12)
{
objInvCumChallan.BookRwCnt = ((objInvCumChallan.BookRwCnt) / 12);
if (objInvCumChallan.BookRwCnt > 0)
{
objInvCumChallan.BookRwCnt++;
}
}
else
{
objInvCumChallan.BookRwCnt = 1;
}
List <InvoiceCumChallanList> lst_InvCumChallan = new List <InvoiceCumChallanList>();
for (int iCnt = 0; iCnt < dtChallanDtl.Rows.Count; iCnt++)
{
InvoiceCumChallanList icc = new InvoiceCumChallanList();
icc.ClassName = Convert.ToString(dtChallanDtl.Rows[iCnt]["Class"].ToString());
icc.Book_Code = Convert.ToString(dtChallanDtl.Rows[iCnt]["Book_Code"].ToString());
icc.Book_Name = Convert.ToString(dtChallanDtl.Rows[iCnt]["book_name"].ToString());
icc.QtyShipped = Convert.ToInt32(dtChallanDtl.Rows[iCnt]["QtyShippedQty"].ToString());
icc.Cartoon = dtChallanDtl.Rows[iCnt]["Cartoon"].ToString();
icc.Remarks = dtChallanDtl.Rows[iCnt]["Remarks"].ToString();
lst_InvCumChallan.Add(icc);
}
objInvCumChallan.TotalAmount = 0;
objInvCumChallan.InvoiceCumChallanCollection = lst_InvCumChallan;
DataTable dt = objDbTrx.GetCircleMasterDetailsByCircleId(Convert.ToInt32(dtChallanDtl.Rows[0]["CircleId"].ToString()));
if (dt.Rows.Count > 0)
{
objInvCumChallan.CircleAddress = Convert.ToString(dt.Rows[0]["CIRCLE_ADDRESS"]);
objInvCumChallan.CirclePinCode = Convert.ToString(dt.Rows[0]["CIRCLE_PINCODE"]);
objInvCumChallan.InspectorName = Convert.ToString(dt.Rows[0]["CIRCLE_OFFICER_NAME"]);
objInvCumChallan.InspectorPhoneNo = Convert.ToString(dt.Rows[0]["MOBILE_NO"]);
objInvCumChallan.InspectorEmailId = Convert.ToString(dt.Rows[0]["EMAIL_ID"]);
dt.Dispose();
}
objInvCumChallan.CustomerOrderNo = "";
dt = objDbTrx.GetCustomerOrderNoByLanguageAndChallanCatId(Convert.ToInt16(dtChallanDtl.Rows[0]["LANGUAGE_ID"].ToString()), Convert.ToInt16(dtChallanDtl.Rows[0]["CHALLAN_BOOK_CATEGORY_ID"].ToString()));
if (dt.Rows.Count > 0)
{
objInvCumChallan.CustomerOrderNo = Convert.ToString(dt.Rows[0]["CUST_ORDER"]);
dt.Dispose();
}
dtChallanDtl.Dispose();
}
return(objInvCumChallan);
}
public ActionResult SaveAndConfirmChallan(InvoiceCumChallan objInvoiceCumChallan, string barcodeList, string duplicatebarcodeList, bool isDraft = false)
{
string ChallanNo = string.Empty;
try
{
var userSessionObject = GlobalSettings.oUserData != null ? GlobalSettings.oUserData : new UserSec();
objInvoiceCumChallan.UserId = userSessionObject.UserId;
objInvoiceCumChallan.InvoiceCumChallanDate = DateTime.Now.ToString();
objInvoiceCumChallan.AY_ID = GlobalSettings.oUserData.AcademicYearId;
if (objInvoiceCumChallan.InvoiceCumChallanCollection != null && objInvoiceCumChallan.InvoiceCumChallanCollection.Count() > default(int))
{
foreach (var ic in objInvoiceCumChallan.InvoiceCumChallanCollection)
{
if (ic.TotalLot > default(int) && !string.IsNullOrWhiteSpace(ic.TotalLotDelimited))
{
List <int> TagIds = new List <int>();
try
{
TagIds = ic.TotalLotDelimited.Split(',').Select(int.Parse).ToList();
if (TagIds != null && TagIds.Count() > default(int))
{
StringBuilder sb = new StringBuilder();
foreach (var tg in TagIds)
{
sb.Append(string.Format("{0} pack, {1} book(s); ", (ic.QtyShipped > 0 ? (ic.QtyShipped > tg ? (ic.QtyShipped / tg) : 1) : 0), tg.ToString()));
}
ic.Cartoon = string.Format("{0} in each pack", sb.ToString().Remove(sb.ToString().LastIndexOf(";")));
//ic.Cartoon = string.Format("{0} pack, {1} Books in each pack", (ic.QtyShipped > 0 ? (ic.QtyShipped > ic.TotalLot ? (ic.QtyShipped / ic.TotalLot) : 1) : 0), ic.TotalLot.ToString());
}
}
catch (Exception)
{
ic.Cartoon = "";
}
}
else
{
ic.Cartoon = "";
}
}
}
if (Convert.ToInt64(objInvoiceCumChallan.ChallanId) != 0)
{
objDbTrx.UpdateInChallan(objInvoiceCumChallan);
//objDbTrx.UpdateInChallanNew(objInvoiceCumChallan,barcodeList,duplicatebarcodeList, isDraft);
}
else
{
objDbTrx.InsertInChallan(objInvoiceCumChallan, GlobalSettings.oAcademicYear.PFX_CHALLAN, GlobalSettings.oAcademicYear.FormatNumberPaddingCount, out ChallanNo);
//objDbTrx.InsertInChallanNew(objInvoiceCumChallan, barcodeList, duplicatebarcodeList, out ChallanNo);
}
//return RedirectToAction("Index", "InvoiceCumChallanReqList");
return(Json(new { Success = 1, Message = string.Format("Challan {0} successfully", string.IsNullOrEmpty(ChallanNo) ? "updated" : "inserted") }, JsonRequestBehavior.AllowGet));
}
catch (Exception ex)
{
objDbTrx.SaveSystemErrorLog(ex, Request.UserHostAddress);
return(Json(new { Success = 0, Message = ex.Message }, JsonRequestBehavior.AllowGet));
}
}
public ActionResult GetBooksReqDetails(string District, string CircleId, string categoryId, string languageId, string ChallanId, bool isPartialViewRequest = false)
{
InvoiceCumChallan lst_invCumChal = new InvoiceCumChallan();
try
{
Int16 AccadYear = Convert.ToInt16(GlobalSettings.oUserData.AcademicYearId);
DataTable dtReqDtl = new DataTable();
if (Convert.ToInt64(ChallanId) != 0)
{
dtReqDtl = objDbTrx.GetChallanDetailsById(Convert.ToInt64(ChallanId));
}
DataTable dtTransaction = objDbTrx.GetChallanListDtlForBarcode(CircleId, categoryId, languageId, ChallanId, AccadYear);
DataTable dt = objDbTrx.GetBinderDtlListByChallanIdOnly(ChallanId);
List <InvoiceCumChallanList> ObjlstInvCumCha = new List <InvoiceCumChallanList>();
if (dtTransaction.Rows.Count > 0)
{
for (int iCnt = 0; iCnt < dtTransaction.Rows.Count; iCnt++)
{
InvoiceCumChallanList icc = new InvoiceCumChallanList();
icc.ClassName = Convert.ToString(dtTransaction.Rows[iCnt]["Class"].ToString());
icc.Book_Code = Convert.ToString(dtTransaction.Rows[iCnt]["Book_Code"].ToString());
icc.Common_Book_Code = Convert.ToString(dtTransaction.Rows[iCnt]["Common_Book_Code"].ToString());
icc.Book_Name = Convert.ToString(dtTransaction.Rows[iCnt]["book_name"].ToString());
icc.NetReqQty = Convert.ToInt32(dtTransaction.Rows[iCnt]["NetReqQtyAfterStockDeduction"].ToString()) > default(int) ? Convert.ToInt32(dtTransaction.Rows[iCnt]["NetReqQtyAfterStockDeduction"].ToString()) : default(int);
icc.AlreadyShippedQty = Convert.ToInt32(dtTransaction.Rows[iCnt]["AlreadyShipped"].ToString());
icc.QtyShipped = 0;
icc.Cartoon = "";
//icc.Cartoon = !string.IsNullOrWhiteSpace(dtTransaction.Rows[iCnt]["LOT"].ToString()) ? string.Format("Lot - {0}, Books per lot - {1}", dtTransaction.Rows[iCnt]["LOT"].ToString(), dtTransaction.Rows[iCnt]["REQ_QTY"].ToString()) : "";
//icc.Lot = dtTransaction.Rows[iCnt]["LOT"].ToString();
//icc.TotBooksPerLot = icc.Cartoon = !string.IsNullOrWhiteSpace(dtTransaction.Rows[iCnt]["LOT"].ToString()) ? string.Format("Lot - {0}, Books per lot - {1}", dtTransaction.Rows[iCnt]["LOT"].ToString(), dtTransaction.Rows[iCnt]["REQ_QTY"].ToString()) : "";
icc.TotalLot = Convert.ToInt32(dtTransaction.Rows[iCnt]["LOT"] != null && !string.IsNullOrWhiteSpace(dtTransaction.Rows[iCnt]["LOT"].ToString()) ? dtTransaction.Rows[iCnt]["LOT"].ToString() : default(int).ToString());
icc.Remarks = "";
if (dtReqDtl != null && dtReqDtl.Rows.Count > default(int))
{
for (int jCnt = 0; jCnt < dtReqDtl.Rows.Count; jCnt++)
{
if (dtTransaction.Rows[iCnt]["Book_Code"].ToString() == dtReqDtl.Rows[jCnt]["Book_Code"].ToString())
{
icc.QtyShipped = Convert.ToInt32(dtReqDtl.Rows[jCnt]["QtyShippedQty"].ToString());
icc.Cartoon = dtReqDtl.Rows[jCnt]["Cartoon"].ToString();
// icc.RemarksId = dtReqDtl.Rows[jCnt]["RemarksID"].ToString();
break;
}
}
}
try
{
icc.RemainBal = (icc.NetReqQty - icc.AlreadyShippedQty) - icc.QtyShipped;
if (icc.RemainBal < 1)
{
icc.RemainBal = 0;
}
}
catch
{
icc.RemainBal = 0;
}
icc.BookSurplusQty = "Gross Req: " + dtTransaction.Rows[iCnt]["TOTAL"].ToString() + ",<br/> Stock total: " + dtTransaction.Rows[iCnt]["STOCK_TOTAL"].ToString() + ",<br/> Already Shiped: " + dtTransaction.Rows[iCnt]["ALREADYSHIPPED"].ToString() + ",<br/> Extra Book " + dtTransaction.Rows[iCnt]["SURPLUS_QTY"].ToString() + " " + (dtTransaction.Rows[iCnt]["SURPLUS_MODE"].ToString() == "PER" ? "%" : "Copies");
ObjlstInvCumCha.Add(icc);
}
if (dt != null && dt.Rows.Count > default(int))
{
if (ObjlstInvCumCha != null && ObjlstInvCumCha.Count() > default(int))
{
List <BinderDtlListByChallan> lst = new List <BinderDtlListByChallan>();
for (int i = 0; i < dt.Rows.Count; i++)
{
BinderDtlListByChallan obj = new BinderDtlListByChallan();
obj.BOOK_CODE = dt.Rows[i]["BOOK_CODE"].ToString();
obj.COMMON_BOOK_CODE = dt.Rows[i]["COMMON_BOOK_CODE"].ToString();
obj.TotalScannedCount = Convert.ToInt32(dt.Rows[i]["TotalScannedCount"].ToString());
obj.LOT = Convert.ToInt32(dt.Rows[i]["LOT"].ToString());
lst.Add(obj);
}
foreach (var item in ObjlstInvCumCha)
{
try
{
IEnumerable <BinderDtlListByChallan> obNew = lst.Where(s => s.BOOK_CODE == item.Book_Code);
if (obNew != null && obNew.Count() > default(int))
{
var lstOb = obNew.GroupBy(x => x.BOOK_CODE).Select(g => new {
Key = g.Key,
Value = g.Sum(s => s.TotalScannedCount),
LOT = g.First().LOT,
LOTDELIMITED = string.Join(",", g.Select(c => c.LOT.ToString()).ToArray())
});
var ob = lstOb.FirstOrDefault();
item.TotalLot = ob != null ? ob.LOT : item.TotalLot;
item.TotalLotDelimited = ob != null ? (string.IsNullOrWhiteSpace(ob.LOTDELIMITED) ? item.TotalLot.ToString() : ob.LOTDELIMITED) : item.TotalLot.ToString();
item.QtyShipped = ob != null ? ob.Value : item.QtyShipped;
item.RemainBal = (item.NetReqQty - item.AlreadyShippedQty) - item.QtyShipped;
if (item.RemainBal < 1)
{
item.RemainBal = 0;
}
}
//var ob = lst.Where(s => s.BOOK_CODE == item.Book_Code).FirstOrDefault();
//item.TotalLot = ob != null ? ob.LOT : item.TotalLot;
////item.TotalLotDelimited = "";
//item.QtyShipped = ob != null ? ob.TotalScannedCount : item.QtyShipped;
//item.RemainBal = (item.NetReqQty - item.AlreadyShippedQty) - item.QtyShipped;
//if (item.RemainBal < 1)
// item.RemainBal = 0;
}
catch (Exception) { }
}
}
}
lst_invCumChal.TotalAmount = 0;
lst_invCumChal.InvoiceCumChallanCollection = ObjlstInvCumCha.Where(o => o.NetReqQty > 0).ToList();
}
dtTransaction.Dispose();
}
catch (Exception ex)
{
objDbTrx.SaveSystemErrorLog(ex, Request.UserHostAddress);
}
if (isPartialViewRequest)
{
return(PartialView("~/Views/InvoiceCumChallanReqList/_ReqBookDtl.cshtml", lst_invCumChal));
}
else
{
return(Json(lst_invCumChal, JsonRequestBehavior.AllowGet));
}
}
public JsonResult GetChallanViewData(string startDate, string endDate, string PendingOnly)
{
List <InvoiceCumChallan> objChallanList = new List <InvoiceCumChallan>();
try
{
string CircleId = "-1";
try { CircleId = GlobalSettings.oUserData.CircleID; }
catch { CircleId = "-1"; }
DataTable dt = objDbTrx.GetChallanDtlByCircleId(startDate, endDate, CircleId, (PendingOnly.ToUpper() == "TRUE" ? "1" : "0"));
if (dt.Rows.Count > 0)
{
for (int iCnt = 0; iCnt < dt.Rows.Count; iCnt++)
{
InvoiceCumChallan icc = new InvoiceCumChallan();
icc.ChallanId = Convert.ToInt64(dt.Rows[iCnt]["ID"].ToString());
icc.InvoiceCumChallanNo = Convert.ToString(dt.Rows[iCnt]["Challan_Number"].ToString());
icc.CircleId = Convert.ToInt32(dt.Rows[iCnt]["CircleId"].ToString());
icc.InvoiceCumChallanDate = Convert.ToDateTime(dt.Rows[iCnt]["Challan_Date"].ToString()).ToString("dd-MMM-yyyy");
icc.CircleName = Convert.ToString(dt.Rows[iCnt]["Circle_Name"].ToString());
icc.CategoryName = Convert.ToString(dt.Rows[iCnt]["CHALLAN_BOOK_CATEGORY"].ToString());
icc.DistrictName = dt.Rows[iCnt]["DISTRICT"].ToString();
icc.Language = Convert.ToString(dt.Rows[iCnt]["LANGUAGE"].ToString());
icc.Transporter = Convert.ToString(dt.Rows[iCnt]["Transport_Name"].ToString());
icc.CONSIGNEE_NO = Convert.ToString(dt.Rows[iCnt]["CONSIGNEE_NO"].ToString());
icc.VEHICLE_NO = Convert.ToString(dt.Rows[iCnt]["VEHICLE_NO"].ToString());
icc.ReceivedAtCircle = Convert.ToString(dt.Rows[iCnt]["RECEIVED_AT_CIRCLE"].ToString());
icc.ReceivedBy = "";
// -- 4.12.18 Anik da part
//try
//{
// var dtx = objDbTrx.GetCircleChallanCommentById_SeparateTable(Convert.ToInt32(dt.Rows[iCnt]["ID"].ToString()));
// if (dtx .Rows.Count > 0)
// {
// icc.ChallanComment = Convert.ToString(dt.Rows[0]["ChallanComment"].ToString());
// }
//}
//catch
//{
// icc.ChallanComment = string.Empty;
//}
icc.ChallanComment = Convert.ToString(dt.Rows[iCnt]["ChallanComment"].ToString());
icc.ReceivedTimeStamp = "";
if (icc.ReceivedAtCircle == "1")
{
icc.ReceivedBy = Convert.ToString(dt.Rows[iCnt]["RECEIVED_BY"].ToString());
icc.ReceivedTimeStamp = Convert.ToDateTime(dt.Rows[iCnt]["RECEIVED_TS"].ToString()).ToString("dd-MMM-yyyy");
}
objChallanList.Add(icc);
}
}
}
catch (Exception ex)
{
objDbTrx.SaveSystemErrorLog(ex, Request.UserHostAddress);
}
return(Json(objChallanList));
}
