public JsonResult DeleteChallanEntry(int srNo, int ChallanId, int ChallanOrderId)
{
var result = false;
if (ChallanId == 0)
{
var ChallanEntryList = (List <tblChallanEntryDTO>)Session["ChallanEntrySession"];
if (ChallanEntryList == null)
{
ChallanEntryList = new List <tblChallanEntryDTO>();
}
var ChallanEntry = ChallanEntryList.Where(be => be.SrNo == srNo).FirstOrDefault();
ChallanEntryList.Remove(ChallanEntry);
Session["ChallanEntrySession"] = SetChallanEntrySrNo(ChallanEntryList);
result = true;
}
else
{
result = ChallanBusinessLogic.DeleteChallanEntry(ChallanOrderId);
}
if (result)
{
return(Json(new { Success = true, Message = "Delete Successfully." }));
}
return(Json(new { Success = false, Message = "Error in transaction." }));
}
public PartialViewResult ChallanEntryPartial(int srNO, int ChallanId, int ChallanOrderId)
{
var tblChallanEntryDTO = new tblChallanEntryDTO();
if (ChallanId == 0)
{
if (srNO > 0)
{
var ChallanEntryList = (List <tblChallanEntryDTO>)Session["ChallanEntrySession"];
if (ChallanEntryList == null)
{
ChallanEntryList = new List <tblChallanEntryDTO>();
}
tblChallanEntryDTO = ChallanEntryList.Where(be => be.SrNo == srNO).FirstOrDefault();
}
}
else
{
if (ChallanOrderId > 0)
{
tblChallanEntryDTO = ChallanBusinessLogic.GetChallanEntry(ChallanOrderId);
}
}
return(PartialView(tblChallanEntryDTO));
}
public JsonResult ChallanEntryPartial(tblChallanEntryDTO tblChallanEntryDTO)
{
if (tblChallanEntryDTO.ChallanId == 0)
{
var ChallanEntryList = (List <tblChallanEntryDTO>)Session["ChallanEntrySession"];
if (ChallanEntryList == null)
{
ChallanEntryList = new List <tblChallanEntryDTO>();
}
if (tblChallanEntryDTO.SrNo == 0)
{
ChallanEntryList.Add(tblChallanEntryDTO);
}
else
{
var ChallanEntry = ChallanEntryList.Where(be => be.SrNo == tblChallanEntryDTO.SrNo).FirstOrDefault();
ChallanEntry.ChallanId = tblChallanEntryDTO.ChallanId;
ChallanEntry.ChallanEntryNo = tblChallanEntryDTO.ChallanEntryNo;
ChallanEntry.ChallanId = tblChallanEntryDTO.ChallanId;
ChallanEntry.BkgStnCode = tblChallanEntryDTO.BkgStnCode;
ChallanEntry.CNNoWithAlphaCode = tblChallanEntryDTO.CNNoWithAlphaCode;
ChallanEntry.PackagesNos = tblChallanEntryDTO.PackagesNos;
ChallanEntry.PackagesMethod = tblChallanEntryDTO.PackagesMethod;
ChallanEntry.SaidToContain = tblChallanEntryDTO.SaidToContain;
ChallanEntry.ActualWeightKgs = tblChallanEntryDTO.ActualWeightKgs;
ChallanEntry.DestinationName = tblChallanEntryDTO.DestinationName;
}
Session["ChallanEntrySession"] = SetChallanEntrySrNo(ChallanEntryList);
}
else
{
ChallanBusinessLogic.SaveChallanEntry(tblChallanEntryDTO);
}
return(Json(new { Success = true, Message = "" }));
}
private void GridViewChallan_CellContentClick(object sender, DataGridViewCellEventArgs e)
{
string Action = this.GridViewChallan.Columns[e.ColumnIndex].HeaderText;
if (Action == "Edit")
{
frmEntryChallan frm = new frmEntryChallan();
ChallanId = Convert.ToInt32(GridViewChallan.Rows[e.RowIndex].Cells[0].Value);
frm.ChallanId = ChallanId;
frm.FormClosed += frmParty_FormClosed;
frm.ShowInTaskbar = false;
frm.Show();
}
if (Action == "Delete")
{
try
{
ChallanId = Convert.ToInt32(GridViewChallan.Rows[e.RowIndex].Cells[0].Value);
var messageBoxResult = MessageBox.Show("Are you sure want to delete this record?", "Delete", MessageBoxButtons.YesNo);
if (messageBoxResult == DialogResult.Yes)
{
var result = ChallanBusinessLogic.Delete(ChallanId);
MessageBox.Show("Party deleted successfully.");
FillGridData();
}
}
catch (Exception)
{
MessageBox.Show("Party already used some where else can't deleted successfully.");
}
}
}
public JsonResult DeleteChallan(int ChallanId)
{
var result = ChallanBusinessLogic.Delete(ChallanId);
if (result)
{
return(Json(new { Success = true, Message = "Delete Successfully." }));
}
return(Json(new { Success = false, Message = "Error in transaction." }));
}
public ActionResult Save(int id)
{
tblChallanDTO tblChallanDTO = new tblChallanDTO();
if (id == 0)
{
tblChallanDTO = new tblChallanDTO();
tblChallanDTO.ChallanNo = (ChallanBusinessLogic.GetChallanNo() + 1);
}
else
{
tblChallanDTO = ChallanBusinessLogic.Get(id);
}
return(View(tblChallanDTO));
}
public ActionResult _AjaxGetChallanEntrys(int ChallanId)
{
List <tblChallanEntryDTO> ChallanEntryList = new List <tblChallanEntryDTO>();
if (ChallanId == 0)
{
ChallanEntryList = (List <tblChallanEntryDTO>)Session["ChallanEntrySession"];
if (ChallanEntryList == null)
{
ChallanEntryList = new List <tblChallanEntryDTO>();
}
}
else
{
ChallanEntryList = ChallanBusinessLogic.GetChallanEntryList(ChallanId);
}
return(View(new GridModel(SetChallanEntrySrNo(ChallanEntryList))));
}
public ActionResult Save(tblChallanDTO tblChallanDTO)
{
if (ModelState.IsValid)
{
var resultDuplicateBllNo = ChallanBusinessLogic.CheckDuplicateChallanNo(tblChallanDTO.ChallanId, tblChallanDTO.ChallanNo ?? 0);
if (resultDuplicateBllNo)
{
ModelState.AddModelError("ChallanNo", "Challan no already exists.");
}
else
{
if (tblChallanDTO.ChallanId == 0)
{
tblChallanDTO.ChallanEntryList = (List <tblChallanEntryDTO>)Session["ChallanEntrySession"];
}
var result = ChallanBusinessLogic.Save(tblChallanDTO);
return(RedirectToAction("Index"));
}
}
return(View(tblChallanDTO));
}
public ActionResult _AjaxGetChallans()
{
var Challans = ChallanBusinessLogic.GetAll();
return(View(new GridModel(Challans)));
}
private void FillGridData()
{
var ChallanList = ChallanBusinessLogic.GetAll();
GridViewChallan.DataSource = ChallanList;
}
private void frmEntryChallan_Load(object sender, EventArgs e)
{
clearData();
if (ChallanId > 0)
{
var tblChallanDTO = ChallanBusinessLogic.Get(ChallanId);
txtLorryChallenNo.Text = (tblChallanDTO.ChallanNo).ToString();
dpChallanDate.Value = tblChallanDTO.ChallanDateTime.Value;
txtVehicleNo.Text = tblChallanDTO.VehicleNo;
txtVehicleType.Text = tblChallanDTO.VehicleType;
txtMake.Text = tblChallanDTO.VechicleMake;
txtModel.Text = tblChallanDTO.VehicleModel;
txtLoading.Text = tblChallanDTO.VehicleNoOfPointLoading;
txtUnloading.Text = tblChallanDTO.Vehicle4NoOfPointUnLoading;
txtCompanyFeetCode.Text = tblChallanDTO.VehicleFleetCode;
txtFromBrCode.Text = tblChallanDTO.FromBrCode;
txtLoadedFrom.Text = tblChallanDTO.LoadedForm;
txtToBrCode.Text = tblChallanDTO.ToBrCode;
txtDestination.Text = tblChallanDTO.Destination;
txtDistance.Text = tblChallanDTO.DistanceKM;
txtScheduleDateofArrival.Text = tblChallanDTO.ScheduleDateofActual;
txtVehicleEngineNo.Text = tblChallanDTO.VechicleEngineNo;
txtVehicleChassisNo.Text = tblChallanDTO.VechicleChassisNo;
txtDriverMobileNo.Text = tblChallanDTO.DriverMobileNo;
txtDriverAddress.Text = tblChallanDTO.DriverAddress;
txtTaxTokenNumber.Text = tblChallanDTO.TaxTokenNo;
txtTaxtokenValidUpto.Text = tblChallanDTO.TaxTokenNoValidUpto;
txtDriverLicenceNo.Text = tblChallanDTO.DriverLicenseNo;
txtIssuedFrom.Text = tblChallanDTO.LicenseIssuedFrom;
txtLicenceValidUpto.Text = tblChallanDTO.LicenseValidUpto;
txtOwnerName.Text = tblChallanDTO.VechicleOwnerName;
txtRoadPermitNumber.Text = tblChallanDTO.RoadPermitNo;
txtRoadPermitValidUpto3.Text = tblChallanDTO.RoadPermitValidUpto;
txtVehicleOwnerMobileMobileNo.Text = tblChallanDTO.VechicleOwnerMobileNo;
txtVehicleOwnerAddress.Text = tblChallanDTO.VechicleOwnerAddress;
txtInsPolicyNo.Text = tblChallanDTO.InsPolicyNo;
txtPANNo.Text = tblChallanDTO.VechicleOwnerPanNo;
txtAgentName.Text = tblChallanDTO.VechicleAgentName;
txtEngagedByEmpCode1.Text = tblChallanDTO.VechicleEngagedByNameWithEmpCode1;
txtAgentMobileNumber.Text = tblChallanDTO.VechicleMobileNo;
txtAgentAddress.Text = tblChallanDTO.VechicleAgentAddress;
txtEngagedByEmpCode2.Text = tblChallanDTO.VechicleEngagedByNameWithEmpCode2;
txtVehicleFinancier.Text = tblChallanDTO.VechicleFinancierDetails;
txtLoadingAdviceNo.Text = tblChallanDTO.BrokerLoadingAdviceNoDate;
txtMaterialUnloadingBy.Text = tblChallanDTO.MaterialUnLoadingBy;
txtTotalPackageNo.Text = (tblChallanDTO.PayableTotalPackages).ToString();
txtChargedWeightKg.Text = (tblChallanDTO.PayableChargedWeight).ToString();
txtRatePerTon.Text = (tblChallanDTO.PayableRatePerTon).ToString();
txtTotalLorryHire.Text = (tblChallanDTO.TotalLorryHire).ToString();
txtITDC.Text = (tblChallanDTO.ITDSDeduction).ToString();
txtPartLorryHire.Text = (tblChallanDTO.PartyLorryHire).ToString();
txtBalanceLorryHire.Text = (tblChallanDTO.BalanceLorryHire).ToString();
int i = 1;
foreach (var item in tblChallanDTO.ChallanEntryList)
{
item.SrNo = i++;
CommonClass.tblChallanEntryDTO.Add(item);
}
fillGridData();
}
else
{
GenerateCode();
}
}
private void GenerateCode()
{
txtLorryChallenNo.Text = Convert.ToString(ChallanBusinessLogic.GetChallanNo() + 1);
}
private void btnSave_Click(object sender, EventArgs e)
{
if (IsFormValidate())
{
if (CommonClass.tblChallanEntryDTO.Count() == 0)
{
MessageBox.Show("Enter Atlease On Challan Entry");
return;
}
tblChallanDTO dto = new tblChallanDTO();
if (ChallanId > 0)
{
dto.ChallanId = ChallanId;
}
dto.ChallanNo = Convert.ToInt32(txtLorryChallenNo.Text);
dto.ChallanDateTime = dpChallanDate.Value;
dto.VehicleNo = txtVehicleNo.Text;
dto.VehicleType = txtVehicleType.Text;
dto.VechicleMake = txtMake.Text;
dto.VehicleModel = txtModel.Text;
dto.VehicleNoOfPointLoading = txtLoading.Text;
dto.Vehicle4NoOfPointUnLoading = txtUnloading.Text;
dto.VehicleFleetCode = txtCompanyFeetCode.Text;
dto.FromBrCode = txtFromBrCode.Text;
dto.LoadedForm = txtLoadedFrom.Text;
dto.ToBrCode = txtToBrCode.Text;
dto.Destination = txtDestination.Text;
dto.DistanceKM = txtDistance.Text;
dto.ScheduleDateofActual = txtScheduleDateofArrival.Text;
dto.VechicleEngineNo = txtVehicleEngineNo.Text;
dto.VechicleChassisNo = txtVehicleChassisNo.Text;
dto.DriverMobileNo = txtDriverMobileNo.Text;
dto.DriverAddress = txtDriverAddress.Text;
dto.TaxTokenNo = txtTaxTokenNumber.Text;
dto.TaxTokenNoValidUpto = txtTaxtokenValidUpto.Text;
dto.DriverLicenseNo = txtDriverLicenceNo.Text;
dto.LicenseIssuedFrom = txtIssuedFrom.Text;
dto.LicenseValidUpto = txtLicenceValidUpto.Text;
dto.VechicleOwnerName = txtOwnerName.Text;
dto.RoadPermitNo = txtRoadPermitNumber.Text;
dto.RoadPermitValidUpto = txtRoadPermitValidUpto3.Text;
dto.VechicleOwnerMobileNo = txtVehicleOwnerMobileMobileNo.Text;
dto.VechicleOwnerAddress = txtVehicleOwnerAddress.Text;
dto.InsPolicyNo = txtInsPolicyNo.Text;
dto.VechicleOwnerPanNo = txtPANNo.Text;
dto.VechicleAgentName = txtAgentName.Text;
dto.VechicleEngagedByNameWithEmpCode1 = txtEngagedByEmpCode1.Text;
dto.VechicleMobileNo = txtAgentMobileNumber.Text;
dto.VechicleAgentAddress = txtAgentAddress.Text;
dto.VechicleEngagedByNameWithEmpCode2 = txtEngagedByEmpCode2.Text;
dto.VechicleFinancierDetails = txtVehicleFinancier.Text;
dto.BrokerLoadingAdviceNoDate = txtLoadingAdviceNo.Text;
dto.MaterialUnLoadingBy = txtMaterialUnloadingBy.Text;
dto.PayableTotalPackages = txtTotalPackageNo.Text.Trim() == "" ? 0 : Convert.ToDouble(txtTotalPackageNo.Text);
dto.PayableChargedWeight = txtChargedWeightKg.Text.Trim() == "" ? 0 : Convert.ToDouble(txtChargedWeightKg.Text);
dto.PayableRatePerTon = txtRatePerTon.Text.Trim() == "" ? 0 : Convert.ToDouble(txtRatePerTon.Text);
dto.TotalLorryHire = txtTotalLorryHire.Text.Trim() == "" ? 0 : Convert.ToDouble(txtTotalLorryHire.Text);
dto.ITDSDeduction = txtITDC.Text.Trim() == "" ? 0 : Convert.ToDouble(txtITDC.Text);
dto.PartyLorryHire = txtPartLorryHire.Text.Trim() == "" ? 0 : Convert.ToDouble(txtPartLorryHire.Text);
dto.BalanceLorryHire = txtBalanceLorryHire.Text.Trim() == "" ? 0 : Convert.ToDouble(txtBalanceLorryHire.Text);
dto.ChallanEntryList = CommonClass.tblChallanEntryDTO;
var resultDuplicateBllNo = ChallanBusinessLogic.CheckDuplicateChallanNo(ChallanId, Convert.ToInt32(txtLorryChallenNo.Text));
if (resultDuplicateBllNo)
{
MessageBox.Show("Challan no already exists.");
}
else
{
var result = ChallanBusinessLogic.Save(dto);
if (result > 0)
{
if (ChallanId > 0)
{
this.Close();
}
else
{
clearData();
}
}
else
{
MessageBox.Show("Transaction Fail");
}
}
}
}
