public Int64 InsertMultpleFromCity(Int64 HeadIdno, System.Web.UI.WebControls.CheckBoxList chklistFromcity)
{
Int64 fromcityDetlIdno = 0;
try
{
using (TransportMandiEntities db = new TransportMandiEntities(MultipleDBDAL.strDynamicConString()))
{
for (int i = 0; i < chklistFromcity.Items.Count; i++)
{
if (chklistFromcity.Items[i].Selected == true)
{
tblFrmCityDetl obj = new tblFrmCityDetl();
obj.User_Idno = HeadIdno;
obj.FrmCity_Idno = Convert.ToInt32(chklistFromcity.Items[i].Value);
db.AddTotblFrmCityDetls(obj);
db.SaveChanges();
fromcityDetlIdno = obj.FrmCityDetl_Idno;
}
}
}
}
catch (Exception ex)
{
throw (ex);
}
return(fromcityDetlIdno);
}
public Int64 UpdateMultpleFromCity(Int64 HeadIdno, System.Web.UI.WebControls.CheckBoxList chklistFromcity)
{
Int64 ID = 0;
try
{
using (TransportMandiEntities db = new TransportMandiEntities(MultipleDBDAL.strDynamicConString()))
{
List <tblFrmCityDetl> objDetls = db.tblFrmCityDetls.Where(pcd => pcd.User_Idno == HeadIdno).ToList();
if (objDetls.Count > 0)
{
foreach (tblFrmCityDetl pcd in objDetls)
{
db.DeleteObject(pcd);
db.SaveChanges();
}
}
for (int i = 0; i < chklistFromcity.Items.Count; i++)
{
if (chklistFromcity.Items[i].Selected == true)
{
tblFrmCityDetl obj = new tblFrmCityDetl();
obj.User_Idno = HeadIdno;
obj.FrmCity_Idno = Convert.ToInt32(chklistFromcity.Items[i].Value);
db.AddTotblFrmCityDetls(obj);
db.SaveChanges();
ID = obj.FrmCityDetl_Idno;
}
}
}
}
catch (Exception ex)
{
throw (ex);
}
return(ID);
}