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; }