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 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 static int Save(tblChallanDTO tblChallanDTO)
{
using (var dbObject = new BRCTransportDBEntities())
{
var tblChallanObject = tblChallanDTO.ToEntity();
if (tblChallanDTO.ChallanId == 0)
{
dbObject.tblChallans.Add(tblChallanObject);
if (tblChallanDTO.ChallanEntryList != null)
{
foreach (var ChallanEntry in tblChallanDTO.ChallanEntryList)
{
dbObject.tblChallanEntries.Add(ChallanEntry.ToEntity());
}
}
}
else
{
tblChallanObject = dbObject.tblChallans.Find(tblChallanDTO.ChallanId);
tblChallanObject.ChallanNo = tblChallanDTO.ChallanNo;
tblChallanObject.ChallanDateTime = tblChallanDTO.ChallanDateTime;
tblChallanObject.VehicleNo = tblChallanDTO.VehicleNo;
tblChallanObject.VehicleType = tblChallanDTO.VehicleType;
tblChallanObject.VechicleMake = tblChallanDTO.VechicleMake;
tblChallanObject.VehicleModel = tblChallanDTO.VehicleModel;
tblChallanObject.VehicleNoOfPointLoading = tblChallanDTO.VehicleNoOfPointLoading;
tblChallanObject.Vehicle4NoOfPointUnLoading = tblChallanDTO.Vehicle4NoOfPointUnLoading;
tblChallanObject.VehicleFleetCode = tblChallanDTO.VehicleFleetCode;
tblChallanObject.FromBrCode = tblChallanDTO.FromBrCode;
tblChallanObject.LoadedForm = tblChallanDTO.LoadedForm;
tblChallanObject.ToBrCode = tblChallanDTO.ToBrCode;
tblChallanObject.Destination = tblChallanDTO.Destination;
tblChallanObject.DistanceKM = tblChallanDTO.DistanceKM;
tblChallanObject.ScheduleDateofActual = tblChallanDTO.ScheduleDateofActual;
tblChallanObject.VechicleEngineNo = tblChallanDTO.VechicleEngineNo;
tblChallanObject.VechicleChassisNo = tblChallanDTO.VechicleChassisNo;
tblChallanObject.DriverName = tblChallanDTO.DriverName;
tblChallanObject.DriverMobileNo = tblChallanDTO.DriverMobileNo;
tblChallanObject.DriverAddress = tblChallanDTO.DriverAddress;
tblChallanObject.TaxTokenNo = tblChallanDTO.TaxTokenNo;
tblChallanObject.TaxTokenNoValidUpto = tblChallanDTO.TaxTokenNoValidUpto;
tblChallanObject.TaxTokenNoIssuedFrom = tblChallanDTO.TaxTokenNoIssuedFrom;
tblChallanObject.DriverLicenseNo = tblChallanDTO.DriverLicenseNo;
tblChallanObject.LicenseIssuedFrom = tblChallanDTO.LicenseIssuedFrom;
tblChallanObject.LicenseValidUpto = tblChallanDTO.LicenseValidUpto;
tblChallanObject.RoadPermitNo = tblChallanDTO.RoadPermitNo;
tblChallanObject.RoadPermitValidUpto = tblChallanDTO.RoadPermitValidUpto;
tblChallanObject.VechicleOwnerName = tblChallanDTO.VechicleOwnerName;
tblChallanObject.VechicleOwnerMobileNo = tblChallanDTO.VechicleOwnerMobileNo;
tblChallanObject.VechicleOwnerPanNo = tblChallanDTO.VechicleOwnerPanNo;
tblChallanObject.VechicleOwnerAddress = tblChallanDTO.VechicleOwnerAddress;
tblChallanObject.InsPolicyNo = tblChallanDTO.InsPolicyNo;
tblChallanObject.InsCoWithStn = tblChallanDTO.InsCoWithStn;
tblChallanObject.VechicleEngagedByNameWithEmpCode1 = tblChallanDTO.VechicleEngagedByNameWithEmpCode1;
tblChallanObject.VechicleEngagedByNameWithEmpCode2 = tblChallanDTO.VechicleEngagedByNameWithEmpCode2;
tblChallanObject.VechicleAgentName = tblChallanDTO.VechicleAgentName;
tblChallanObject.VechicleMobileNo = tblChallanDTO.VechicleMobileNo;
tblChallanObject.VechicleAgentAddress = tblChallanDTO.VechicleAgentAddress;
tblChallanObject.VechicleFinancierDetails = tblChallanDTO.VechicleFinancierDetails;
tblChallanObject.BrokerLoadingAdviceNoDate = tblChallanDTO.BrokerLoadingAdviceNoDate;
tblChallanObject.GrandTotalPKG = tblChallanDTO.GrandTotalPKG;
tblChallanObject.GrandTotalKGS = tblChallanDTO.GrandTotalKGS;
tblChallanObject.MaterialUnLoadingBy = tblChallanDTO.MaterialUnLoadingBy;
tblChallanObject.PayableTotalPackages = tblChallanDTO.PayableTotalPackages;
tblChallanObject.PayableChargedWeight = tblChallanDTO.PayableChargedWeight;
tblChallanObject.PayableRatePerTon = tblChallanDTO.PayableRatePerTon;
tblChallanObject.TotalLorryHire = tblChallanDTO.TotalLorryHire;
tblChallanObject.ITDSDeduction = tblChallanDTO.ITDSDeduction;
tblChallanObject.PartyLorryHire = tblChallanDTO.PartyLorryHire;
tblChallanObject.BalanceLorryHire = tblChallanDTO.BalanceLorryHire;
List <tblChallanEntry> entry = new List <tblChallanEntry>();
entry = dbObject.tblChallanEntries.Where(h => h.ChallanId == tblChallanDTO.ChallanId).ToList();
foreach (var item in entry)
{
dbObject.tblChallanEntries.Remove(item);
}
if (tblChallanDTO.ChallanEntryList != null)
{
foreach (var billEntry in tblChallanDTO.ChallanEntryList)
{
billEntry.ChallanId = tblChallanDTO.ChallanId;
dbObject.tblChallanEntries.Add(billEntry.ToEntity());
}
}
}
dbObject.SaveChanges();
return(tblChallanObject.ChallanId);
}
}
public static int Save(tblChallanDTO tblChallanDTO)
{
return(ChallanRepository.Save(tblChallanDTO));
}
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");
}
}
}
}
