private void Populate(string tripId)
{
lnkbtnPrint.Visible = true;
lnkbtnSubmit.Text = "Update";
Int64 tripIdno = Convert.ToInt64(tripId);
ManualTripSheetDAL obj = new ManualTripSheetDAL();
tblManualTripHead mt = obj.GetTripSheet(tripIdno);
txtTripNo.Text = mt.Trip_No.ToString();
txtTripDate.Text = ((mt.Trip_Date == null || mt.Trip_Date.ToString() == "") ? "" : Convert.ToDateTime(mt.Trip_Date.ToString()).ToString("dd-MM-yyyy"));
ddlCompFromCity.SelectedValue = mt.BaseCity_Idno.ToString();
ddlTruckNo.SelectedValue = mt.Truck_Idno.ToString();
ddlSender.SelectedValue = mt.Party_Idno.ToString();
ddlFromCity.SelectedValue = mt.FromCity_idno.ToString();
ddlToCity.SelectedValue = mt.ToCity_idno.ToString();
txtDriverName.Text = mt.Driver_Name.ToString();
txkStartKms.Text = mt.StartKms.ToString();
txkEndKms.Text = mt.EndKms.ToString();
ddlDateRange.SelectedValue = mt.Year_Idno.ToString();
txtItemName.Text = mt.Item_Name.ToString();
txtItemSize.Text = mt.Item_Size.ToString();
ddlRateType.SelectedValue = mt.Rate_Type.ToString();
txtQuantity.Text = mt.Quantity.ToString();
txtGweight.Text = mt.Gross_Weight.ToString();
txtAweight.Text = mt.Actual_Weight.ToString();
txtrate.Text = mt.Item_Rate.ToString();
txtAdvance.Text = mt.Party_Adv.ToString();
txtCommission.Text = mt.Party_Comm.ToString();
txtTotalPartyAdv.Text = mt.TotalParty_Adv.ToString();
txtRTOChallan.Text = mt.RTO_Chln.ToString();
txtDetention.Text = mt.Detention.ToString();
txtTotalAmount.Text = mt.Freight_Amnt.ToString();
txtTotalFreight.Text = mt.GrossFreight_Amnt.ToString();
txtReceived.Text = mt.Received_Amnt.ToString();
ddlRecType.SelectedValue = mt.Rec_Type.ToString();
txtTotalPartyBalance.Text = mt.TotalParty_Bal.ToString();
txtDriver.Text = mt.DriverCash_Amnt.ToString();
txtDiesel.Text = mt.Diesel_Amnt.ToString();
txtDriverAc.Text = mt.DriverAC_Amnt.ToString();
txtTotalVehAdv.Text = mt.TotalVeh_Amnt.ToString();
txtNetTripProfit.Text = mt.NetTrip_Profit.ToString();
if (mt.FixRate == true)
{
chkFixRate.Checked = mt.FixRate == null ? false : Convert.ToBoolean(mt.FixRate);
txtItemName.Text = "";
txtItemSize.Text = "";
txtQuantity.Text = "";
txtrate.Text = "";
txtGweight.Text = "";
txtAweight.Text = "";
ddlRateType.SelectedValue = "0";
txtItemName.Enabled = false;
txtItemSize.Enabled = false;
txtQuantity.Enabled = false;
txtrate.Enabled = false;
txtGweight.Enabled = false;
txtAweight.Enabled = false;
ddlRateType.Enabled = false;
}
}
public tblManualTripHead GetTripSheet(long TripIdno)
{
int value = 0;
tblManualTripHead objTrip = new tblManualTripHead();
using (TransportMandiEntities db = new TransportMandiEntities(MultipleDBDAL.strDynamicConString()))
{
objTrip = db.tblManualTripHeads.Where(t => t.Trip_Idno == TripIdno).FirstOrDefault();
}
return(objTrip);
}
private void Populate(string tripId)
{
lnkbtnPrint.Visible = true;
lnkbtnSubmit.Text = "Update";
Int64 tripIdno = Convert.ToInt64(tripId);
CustomTripSheetDAL obj = new CustomTripSheetDAL();
Int64 MaxTripId = obj.GetMaxId(Convert.ToInt32(ddlDateRange.SelectedValue), ApplicationFunction.ConnectionString());
if (Request.QueryString["TripId"] != null && Convert.ToInt64(Request.QueryString["TripId"]) != MaxTripId)
{
lnkbtnNext.Visible = true;
}
tblManualTripHead mt = obj.GetTripSheet(tripIdno);
if (mt != null)
{
txtTripNo.Text = mt.Trip_No.ToString(); txtTripNo.Enabled = false;
txtTripDate.Text = ((mt.Trip_Date == null || mt.Trip_Date.ToString() == "") ? "" : Convert.ToDateTime(mt.Trip_Date.ToString()).ToString("dd-MM-yyyy")); txtTripDate.Enabled = true;
ddlCompFromCity.SelectedValue = mt.BaseCity_Idno.ToString(); ddlCompFromCity.Enabled = true;
ddlTruckNo.SelectedValue = mt.Truck_Idno.ToString(); ddlTruckNo.Enabled = true;
ddlSender.SelectedValue = mt.Party_Idno.ToString(); ddlSender.Enabled = true;
ddlLane.SelectedValue = mt.Lane_Idno.ToString(); ddlLane.Enabled = true;
txtDriverName.Text = mt.Driver_Name.ToString(); txtDriverName.Enabled = true;
txtdriverno.Text = mt.Driver_No.ToString(); txtdriverno.Enabled = true;
txtVehicleSize.Text = mt.Vehicle_Size.ToString(); txtVehicleSize.Enabled = true;
txkStartKms.Text = mt.StartKms.ToString(); txkStartKms.Enabled = true;
ddlDateRange.SelectedValue = mt.Year_Idno.ToString(); ddlDateRange.Enabled = true;
txtdslqty.Text = mt.DSL_Qty.ToString(); txtdslqty.Enabled = true;
txtdslrate.Text = mt.DSL_Rate.ToString(); txtdslrate.Enabled = true;
txtdslamt.Text = mt.DSL_Amt.ToString(); txtdslamt.Enabled = true;
txtcash.Text = mt.Cash.ToString(); txtcash.Enabled = true;
txttoll.Text = mt.Toll.ToString(); txttoll.Enabled = true;
txtwages.Text = mt.Dihadi.ToString(); txtwages.Enabled = true;
txtfoodexp.Text = mt.Food_Exp.ToString(); txtfoodexp.Enabled = true;
txtrepair.Text = mt.Repair.ToString(); txtrepair.Enabled = true;
txttotaldslqty.Text = mt.Total_DSL_Qty.ToString(); txttotaldslqty.Enabled = true;
txttotaldslamt.Text = mt.Total_DSL_Amt.ToString(); txttotaldslamt.Enabled = true;
txtmilage.Text = mt.Milage.ToString(); txtmilage.Enabled = true;
txtadvdriver.Text = mt.Adv_in_Driver.ToString(); txtadvdriver.Enabled = true;
txtother.Text = mt.Other.ToString(); txtother.Enabled = true;
txtremark.Text = mt.Remark.ToString(); txtremark.Enabled = true;
txttotalamt.Text = mt.Total_Amt.ToString(); txttotalamt.Enabled = true;
txtTotalKms.Text = mt.TotalKms.ToString();
txkEndKms.Text = mt.EndKms.ToString();
txtdslcardamt.Text = mt.DSL_Card_Amt.ToString();
txtdslcardrate.Text = mt.DSL_Card_Rate.ToString();
txtdslcardltr.Text = mt.DSL_Card_Name.ToString();
txtexdslamt.Text = mt.Ex_DSL_Amt.ToString();
txtexdslltr.Text = mt.Ex_DSL_Ltr.ToString();
hidtripid.Value = mt.Trip_Idno.ToString();
}
}
public int DeleteTrip(Int64 HeadId)
{
int value = 0;
using (TransportMandiEntities db = new TransportMandiEntities(MultipleDBDAL.strDynamicConString()))
{
tblManualTripHead qth = db.tblManualTripHeads.Where(h => h.Trip_Idno == HeadId).FirstOrDefault();
List <TblGrDetl> qtd = db.TblGrDetls.Where(d => d.GrHead_Idno == HeadId).ToList();
if (qth != null)
{
db.tblManualTripHeads.DeleteObject(qth);
db.SaveChanges();
value = 1;
}
}
return(value);
}
public void PrintTrip(int PrintType)
{
//PrintType = 1 Then With Vehicle detail Else 2 Without
Int64 tripIdno = Convert.ToInt64(Request.QueryString["TripId"] == null ? "0" : Request.QueryString["TripId"]);
ManualTripSheetDAL obj = new ManualTripSheetDAL();
tblManualTripHead mt = obj.GetTripSheet(tripIdno);
#region Variable declaration
string TripNo = mt.Trip_No.ToString();
string TripDate = mt.Trip_Date.ToString();
string CompFromCity = mt.BaseCity_Idno.ToString();
string TruckNo = mt.Truck_Idno.ToString();
string Sender = mt.Party_Idno.ToString();
string FromCity = mt.FromCity_idno.ToString();
string ToCity = mt.ToCity_idno.ToString();
string DriverName = mt.Driver_Name.ToString();
string StartKms = mt.StartKms.ToString();
string EndKms = mt.EndKms.ToString();
string DateRange = mt.Year_Idno.ToString();
string ItemName = mt.Item_Name.ToString();
string ItemSize = mt.Item_Size.ToString();
string RateType = mt.Rate_Type.ToString();
string Quantity = mt.Quantity.ToString();
string Gweight = mt.Gross_Weight.ToString();
string Aweight = mt.Actual_Weight.ToString();
string rate = mt.Item_Rate.ToString();
string Advance = mt.Party_Adv.ToString();
string Commission = mt.Party_Comm.ToString();
string TotalPartyAdv = mt.TotalParty_Adv.ToString();
string RTOChallan = mt.RTO_Chln.ToString();
string Detention = mt.Detention.ToString();
string TotalAmount = mt.Freight_Amnt.ToString();
string TotalFreight = mt.GrossFreight_Amnt.ToString();
string Received = mt.Received_Amnt.ToString();
string RecType = mt.Rec_Type.ToString();
string TotalPartyBalance = mt.TotalParty_Bal.ToString();
string Driver = mt.DriverCash_Amnt.ToString();
string Diesel = mt.Diesel_Amnt.ToString();
string DriverAc = mt.DriverAC_Amnt.ToString();
string TotalVehAdv = mt.TotalVeh_Amnt.ToString();
string NetTripProfit = mt.NetTrip_Profit.ToString();
#endregion
string str = "PrintManualTrip.aspx?PrintType=" + PrintType +
"&TripNo=" + TripNo +
"&TripDate=" + TripDate +
"&CompFromCity=" + CompFromCity +
"&TruckNo=" + TruckNo +
"&Sender=" + Sender +
"&FromCity=" + FromCity +
"&ToCity=" + ToCity +
"&DriverName=" + DriverName +
"&StartKms=" + StartKms +
"&EndKms=" + EndKms +
"&DateRange=" + DateRange +
"&ItemName=" + ItemName +
"&ItemSize=" + ItemSize +
"&RateType=" + RateType +
"&Quantity=" + Quantity +
"&Gweight=" + Gweight +
"&Aweight=" + Aweight +
"&rate=" + rate +
"&Advance=" + Advance +
"&Commission=" + Commission +
"&TotalPartyAdv=" + TotalPartyAdv +
"&RTOChallan=" + RTOChallan +
"&Detention=" + Detention +
"&TotalAmount=" + TotalAmount +
"&TotalFreight=" + TotalFreight +
"&Received=" + Received +
"&RecType=" + RecType +
"&TotalPartyBalance=" + TotalPartyBalance +
"&Driver=" + Driver +
"&Diesel=" + Diesel +
"&DriverAc=" + DriverAc +
"&TotalVehAdv=" + TotalVehAdv +
"&NetTripProfit=" + NetTripProfit;
Response.Redirect(str);
}
public Int64 UpdateTripSheet(Int64 intTripIdno, Int64 intTripNo, DateTime dtTripDate, Int32 intBaseCityIdno, Int32 TruckNoIdno, Int32 intPartyIDno, Int32 intFromcityIDno, Int32 intTocityIDno, String strDriverName, String strStartKM, String strEndKM, Int32 intYear_Idno,
String ItemName, String ItemSize, Int32 Rate_Type, Double Qty, Double GrossWeight, Double ActualWeight, Double ItemRate, Double PartyAdvance, Double PartyCommission, Double TotalPartyAdv, Double RTOChallan, Double Detention, Double Freight_Amnt, Double GrossFreight_Amnt,
Double Received_Amnt, Int32 Rec_Type, Double TotalParty_Bal, Double DriverCash_Amnt, Double Diesel_Amnt, Double DriverAC_Amnt, Double TotalVev_Amnt, Double NetTrip_Profit, Boolean FixRate)
{
Int64 TripIdno = 0;
using (TransportMandiEntities db = new TransportMandiEntities(MultipleDBDAL.strDynamicConString()))
{
try
{
tblManualTripHead objTripHead = db.tblManualTripHeads.Where(t => t.Trip_No == intTripNo && t.BaseCity_Idno == intBaseCityIdno).FirstOrDefault();
if (objTripHead != null)
{
objTripHead.Trip_No = intTripNo;
objTripHead.Trip_Date = dtTripDate;
objTripHead.BaseCity_Idno = intBaseCityIdno;
objTripHead.Truck_Idno = TruckNoIdno;
objTripHead.Party_Idno = intPartyIDno;
objTripHead.FromCity_idno = intFromcityIDno;
objTripHead.ToCity_idno = intTocityIDno;
objTripHead.Driver_Name = strDriverName;
objTripHead.StartKms = strStartKM;
objTripHead.EndKms = strEndKM;
objTripHead.Year_Idno = intYear_Idno;
objTripHead.Item_Name = ItemName;
objTripHead.Item_Size = ItemSize;
objTripHead.Rate_Type = Rate_Type;
objTripHead.Quantity = Qty;
objTripHead.Gross_Weight = GrossWeight;
objTripHead.Actual_Weight = ActualWeight;
objTripHead.Item_Rate = ItemRate;
objTripHead.Party_Adv = PartyAdvance;
objTripHead.Party_Comm = PartyCommission;
objTripHead.TotalParty_Adv = TotalPartyAdv;
objTripHead.RTO_Chln = RTOChallan;
objTripHead.Detention = Detention;
objTripHead.Freight_Amnt = Freight_Amnt;
objTripHead.GrossFreight_Amnt = GrossFreight_Amnt;
objTripHead.Received_Amnt = Received_Amnt;
objTripHead.Rec_Type = Rec_Type;
objTripHead.TotalParty_Bal = TotalParty_Bal;
objTripHead.DriverCash_Amnt = DriverCash_Amnt;
objTripHead.Diesel_Amnt = Diesel_Amnt;
objTripHead.DriverAC_Amnt = DriverAC_Amnt;
objTripHead.TotalVeh_Amnt = TotalVev_Amnt;
objTripHead.NetTrip_Profit = NetTrip_Profit;
objTripHead.FixRate = FixRate;
db.SaveChanges();
TripIdno = objTripHead.Trip_Idno;
}
else
{
TripIdno = -1;
}
}
catch (Exception Ex)
{
TripIdno = 0;
}
}
return(TripIdno);
}
public Int64 InsertTripSheet(Int64 intTripNo, DateTime dtTripDate, Int32 intBaseCityIdno, Int32 TruckNoIdno, Int32 intPartyIDno, Int32 intLaneIdno, String strDriverName, Int64 intDriverNo, String VehicleSize, String strStartKM, String strEndKM, String strTotalKM, Int32 intYear_Idno,
Double DSLQty, Double DSLRate, Double DSLAmt, Double Cash, Double DSLCardAmt, String DSLCardRate, String DSLCardName, Double Toll, Double Dihadi, Double FoodExp, Double Repair,
Double ExDSLAmt, Double ExDSLLtr, Double TotalDSLQty, Double TotalDSLAmt, Double Milage, Double AdvinDriver, Double Other, String strRemark, Double TotalAmt)
{
Int64 TripIdno = 0;
using (TransportMandiEntities db = new TransportMandiEntities(MultipleDBDAL.strDynamicConString()))
{
try
{
tblManualTripHead objTripHead = db.tblManualTripHeads.Where(t => t.Trip_No == intTripNo && t.BaseCity_Idno == intBaseCityIdno && t.Year_Idno == intYear_Idno).FirstOrDefault();
if (objTripHead == null)
{
objTripHead = new tblManualTripHead();
objTripHead.Trip_No = intTripNo;
objTripHead.Trip_Date = dtTripDate;
objTripHead.BaseCity_Idno = intBaseCityIdno;
objTripHead.Truck_Idno = TruckNoIdno;
objTripHead.Party_Idno = intPartyIDno;
objTripHead.Lane_Idno = intLaneIdno;
objTripHead.Driver_Name = strDriverName;
objTripHead.Driver_No = intDriverNo;
objTripHead.Vehicle_Size = VehicleSize;
objTripHead.StartKms = strStartKM;
objTripHead.EndKms = strEndKM;
objTripHead.TotalKms = strTotalKM;
objTripHead.Year_Idno = intYear_Idno;
objTripHead.DSL_Qty = DSLQty;
objTripHead.DSL_Rate = DSLRate;
objTripHead.DSL_Amt = DSLAmt;
objTripHead.Cash = Cash;
objTripHead.DSL_Card_Amt = DSLCardAmt;
objTripHead.DSL_Card_Rate = DSLCardRate;
objTripHead.DSL_Card_Name = DSLCardName;
objTripHead.Toll = Toll;
objTripHead.Dihadi = Dihadi;
objTripHead.Food_Exp = FoodExp;
objTripHead.Repair = Repair;
objTripHead.Ex_DSL_Amt = ExDSLAmt;
objTripHead.Ex_DSL_Ltr = ExDSLLtr;
objTripHead.Total_DSL_Qty = TotalDSLQty;
objTripHead.Total_DSL_Amt = TotalDSLAmt;
objTripHead.Milage = Milage;
objTripHead.Adv_in_Driver = AdvinDriver;
objTripHead.Other = Other;
objTripHead.Remark = strRemark;
objTripHead.Total_Amt = TotalAmt;
db.tblManualTripHeads.AddObject(objTripHead);
db.SaveChanges();
TripIdno = objTripHead.Trip_Idno;
}
else
{
TripIdno = -1;
}
}
catch (Exception Ex)
{
TripIdno = 0;
}
}
return(TripIdno);
}
