//Insert public bool Insert(DataTable dT, Int32 YearIdno) { bool value = true; using (TransportMandiEntities db = new TransportMandiEntities(MultipleDBDAL.strDynamicConString())) { try { for (int i = 0; i < dT.Rows.Count; i++) { RateMastFT obj = new RateMastFT(); obj.Year_Idno = YearIdno; obj.Loc_Idno = Convert.ToInt32(dT.Rows[i]["City_FIdno"]); obj.LorryTyp_idno = Convert.ToInt32(dT.Rows[i]["Lorry_Idno"]); obj.RateMastFT_Date = Convert.ToDateTime(dT.Rows[i]["Rate_Date"]); obj.ToCity_Idno = Convert.ToInt32(dT.Rows[i]["ToCity_Idno"]); obj.Tot_Frght = Convert.ToDouble(dT.Rows[i]["Item_Rate"]); obj.Status = true; obj.Date_Added = DateTime.Now; obj.Date_Modified = DateTime.Now; db.RateMastFTs.AddObject(obj); db.SaveChanges(); } } catch (Exception Ex) { value = false; } } return(value); }
protected void lnkbtnSave_Click(object sender, EventArgs e) { RateMastFT objRGH = new RateMastFT(); objRGH.LorryTyp_idno = Convert.ToInt32(ddlLorryType.SelectedValue); objRGH.Loc_Idno = Convert.ToInt32(drpBaseCity.SelectedValue); List <RateMastFT> RgDlst = new List <RateMastFT>(); Int64 RateIdno = 0; bool isinsert = false; DtTemp = (DataTable)ViewState["dt"]; if (DtTemp == null || DtTemp.Rows.Count <= 0) { ShowMessage("Please enter details"); return; } RateMastFTDAL obj = new RateMastFTDAL(); if (Convert.ToInt32(ddlLorryType.SelectedValue) <= 0) { ShowMessage("Please select Lorry Type"); ddlLorryType.Focus(); return; } else { using (TransactionScope Tran = new TransactionScope(TransactionScopeOption.Required)) { int value = obj.Delete(Convert.ToInt32(ddlLorryType.SelectedValue), Convert.ToInt32(drpBaseCity.SelectedValue)); if (value > 0) { isinsert = obj.Insert(DtTemp, Convert.ToInt32(ddlDateRange.SelectedValue)); this.Clear(); } else { ShowMessage("Record not saved successfully"); } obj = null; if (isinsert == true) { Tran.Complete(); ShowMessage("Record save successfully"); Clear(); } else { Tran.Dispose(); ShowMessage("Record not saved successfully"); } } } }