public int Delete(Int64 HeadId, Int64 UserIdno, string con)
{
int value = 0;
using (TransportMandiEntities db = new TransportMandiEntities(MultipleDBDAL.strDynamicConString()))
{
TrackingHead TH = db.TrackingHeads.Where(h => h.TrackingHead_Idno == HeadId).FirstOrDefault();
List <TrackingDetl> TD = db.TrackingDetls.Where(d => d.TrackingHead_Idno == HeadId).ToList();
if (TH != null)
{
foreach (var d in TD)
{
db.TrackingDetls.DeleteObject(d);
db.SaveChanges();
}
db.TrackingHeads.DeleteObject(TH);
db.SaveChanges();
value = 1;
}
}
return(value);
}
public Int64 Insert(Int64 trackingIdno, Int64 VehicleNo, string Date, Int64 LaneIdno, Int64 FromCityIdno, Int64 ToCityIdno, Int64 CompName, Int64 FromLoc, DataTable dtDetail)
{
Int64 intValue = 0;
using (TransportMandiEntities db = new TransportMandiEntities(MultipleDBDAL.strDynamicConString()))
{
try
{
TrackingHead objTrackingHead = (from es in db.TrackingHeads where es.TrackingHead_Idno == trackingIdno && es.Vehicle_No == VehicleNo select es).FirstOrDefault();
if (objTrackingHead == null)
{
objTrackingHead = new TrackingHead();
objTrackingHead.Vehicle_No = VehicleNo;
objTrackingHead.Tracking_Date = Convert.ToDateTime(Date);
objTrackingHead.Comp_Id = CompName;
objTrackingHead.From_Loc = FromLoc;
objTrackingHead.Lane_Id = LaneIdno;
objTrackingHead.From_CityIdno = FromCityIdno;
objTrackingHead.To_CityIdno = ToCityIdno;
db.TrackingHeads.AddObject(objTrackingHead);
db.SaveChanges();
intValue = objTrackingHead.TrackingHead_Idno;
if (intValue > 0)
{
foreach (DataRow row in dtDetail.Rows)
{
TrackingDetl objTrackingDetl = new TrackingDetl();
objTrackingDetl.TrackingHead_Idno = intValue;
objTrackingDetl.leg = Convert.ToString(row["Leg"]);
objTrackingDetl.eta = Convert.ToString(row["ETA"]);
objTrackingDetl.ata = Convert.ToString(row["ATA"]);
objTrackingDetl.etd = Convert.ToString(row["ETD"]);
objTrackingDetl.atd = Convert.ToString(row["ATD"]);
objTrackingDetl.tat_in_hrs = Convert.ToString(row["TAT_in_hrs"]);
objTrackingDetl.delay_in_hrs = Convert.ToString(row["Delay_in_hrs"]);
objTrackingDetl.remarks = Convert.ToString(row["Remarks"]);
objTrackingDetl.FromCity = Convert.ToInt64(row["FromCityIdno"]);
objTrackingDetl.ToCity = Convert.ToInt64(row["ToCItyIdno"]);
db.TrackingDetls.AddObject(objTrackingDetl);
}
db.SaveChanges();
}
}
else
{
intValue = -1;
}
}
catch
{
intValue = 0;
}
}
return(intValue);
}
private void Populate(Int64 HeadId)
{
TrackingDAL obj = new TrackingDAL();
TrackingHead trackinghead = obj.selectHead(HeadId);
TrackingDetl trackingdetl = obj.selectDetel(HeadId);
DdlVehicleNo.SelectedValue = Convert.ToString(trackinghead.Vehicle_No);
txtDate.Text = Convert.ToDateTime(trackinghead.Tracking_Date).ToString("dd-MM-yyyy");
DdlLane.SelectedValue = Convert.ToString(trackinghead.Lane_Id);
DdlLane_SelectedIndexChanged(null, null);
DdlFromCity.SelectedValue = Convert.ToString(trackinghead.From_CityIdno);
DdlFromCity_SelectedIndexChanged(null, null);
DdlToCity.SelectedValue = Convert.ToString(trackinghead.To_CityIdno);
DdlToCity_SelectedIndexChanged(null, null);
DdlCompName.SelectedValue = Convert.ToString(trackinghead.Comp_Id);
DdlFromLoc.SelectedValue = Convert.ToString(trackinghead.From_Loc);
dtTemp = obj.selectDetls(ApplicationFunction.ConnectionString(), HeadId);
ViewState["dt"] = dtTemp;
this.BindGridT();
lnkbtnSave.Enabled = true;
obj = null;
}
