private void btnNewChallan_Click(object sender, EventArgs e)
{
ChallanEntry challanentry = new ChallanEntry("", "");
challanentry.OnClose += GenerateChallanList;
challanentry.Show(this);
}
/// <summary>
/// Grid Events
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void dgvChallanList_CellClick(object sender, DataGridViewCellEventArgs e)
{
if (dgvChallanList.Columns[e.ColumnIndex].Name != "Action" && e.RowIndex != -1)
{
if (UserTools._IsEdit)
{
int rowindex = dgvChallanList.SelectedCells[0].RowIndex;
string challanid = dgvChallanList.Rows[rowindex].Cells["challanId"].Value.ToString();
ChallanEntry challanEntry = new ChallanEntry(challanid);
challanEntry.OnClose += GenerateChallanList;
challanEntry.Show(this);
}
else
{
MessageBox.Show("Permission Denied", "Edit", MessageBoxButtons.OK, MessageBoxIcon.Stop);
}
}
}
private void Cmb_SelectedIndexChanged(object sender, EventArgs e)
{
ComboBox cmb = (ComboBox)sender;
if (cmb.Text == "Create Challan")
{
string orderID = dgvBills.CurrentRow.Cells["OrderID"].Value.ToString();
string orderNo = dgvBills.CurrentRow.Cells["No"].Value.ToString();
ChallanEntry frmChallanEntry = new ChallanEntry(orderID, orderNo);
frmChallanEntry.OnClose += GenerateOrderList;
frmChallanEntry.ShowDialog();
}
else if (cmb.Text == "Advance receipt")
{
string orderid = dgvBills.CurrentRow.Cells["Orderid"].Value.ToString();
AdvanceReceipt ar = new AdvanceReceipt(AdvanceReceipt._FromWherere.Order, orderid);
ar.ShowDialog();
}
else if (cmb.Text == "Create Invoice")
{
string name = dgvBills.CurrentRow.Cells["PartyName"].Value.ToString();
string slno = dgvBills.CurrentRow.Cells["slno"].Value.ToString();
Invoice_Direct frmChallanEntry = new Invoice_Direct(slno, name);
frmChallanEntry.OnClose += GenerateOrderList;
frmChallanEntry.ShowDialog();
}
else if (cmb.Text == "Cancel Order")
{
string name = dgvBills.CurrentRow.Cells["PartyName"].Value.ToString();
string slno = dgvBills.CurrentRow.Cells["slno"].Value.ToString();
if (OrderCancel(slno))
{
GenerateOrderList();
}
}
}
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);
}
}
