//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");
}
}
}
}
