public Int64 Insert(string strDistrictName, string strDistrictNameHindi, string strAbb, Int64 intStateIdno, bool bStatus, Int32 empIdno)
{
using (TransportMandiEntities db = new TransportMandiEntities(MultipleDBDAL.strDynamicConString()))
{
Int64 value;
Int32 intCompIdno = 1;
tblDistrictMaster ObjMast = new tblDistrictMaster();
if (IsExists(strDistrictName, intStateIdno, 0))
{
value = -1;
}
else
{
ObjMast.District_Name = strDistrictName;
ObjMast.District_Hindi = strDistrictNameHindi;
ObjMast.State_Idno = intStateIdno;
ObjMast.District_Abbr = strAbb;
ObjMast.Status = bStatus;
ObjMast.Emp_Idno = empIdno;
ObjMast.Date_Added = System.DateTime.Now;
db.AddTotblDistrictMasters(ObjMast);
db.SaveChanges();
value = ObjMast.District_Idno;
}
return(value);
}
}
public Int32 UpdateStatus(int intDistrictIdno, bool bStatus, Int32 empIdno)
{
int value = 0;
try
{
using (TransportMandiEntities db = new TransportMandiEntities(MultipleDBDAL.strDynamicConString()))
{
tblDistrictMaster objDistrictMast = (from mast in db.tblDistrictMasters
where mast.District_Idno == intDistrictIdno
select mast).FirstOrDefault();
if (objDistrictMast != null)
{
objDistrictMast.Status = bStatus;
objDistrictMast.Emp_Idno = empIdno;
objDistrictMast.Date_Modified = System.DateTime.Now;
db.SaveChanges();
value = 1;
}
}
}
catch (Exception ex)
{
}
return(value);
}
public bool IsExists(string strDistrictName, Int64 intStateIdno, Int64 intDistrictIdno)
{
using (TransportMandiEntities db = new TransportMandiEntities(MultipleDBDAL.strDynamicConString()))
{
tblDistrictMaster ObjDistrictMast = null;
if (intDistrictIdno > 0)///for update
{
ObjDistrictMast = (from CM in db.tblDistrictMasters
where CM.District_Name == strDistrictName && CM.State_Idno == intStateIdno &&
CM.District_Idno != intDistrictIdno
select CM).FirstOrDefault();
}
else /// for insert
{
ObjDistrictMast = (from nhu in db.tblDistrictMasters
where nhu.District_Name == strDistrictName && nhu.State_Idno == intStateIdno
select nhu).FirstOrDefault();
}
if (ObjDistrictMast != null)
{
return(true);
}
else
{
return(false);
}
}
}
/// <summary>
/// Delete record from CityMaster
/// </summary>
/// <param name="intColrIdno"></param>
/// <returns></returns>
public int Delete(int intdistrictIdno)
{
int intValue = 0;
try
{
using (TransportMandiEntities db = new TransportMandiEntities(MultipleDBDAL.strDynamicConString()))
{
tblDistrictMaster objMast = (from mast in db.tblDistrictMasters
where mast.District_Idno == intdistrictIdno
select mast).FirstOrDefault();
if (objMast != null)
{
db.DeleteObject(objMast);
db.SaveChanges();
intValue = 1;
}
}
}
catch (Exception Ex)
{
if (Convert.ToBoolean(Ex.InnerException.Message.Contains("The DELETE statement conflicted with the REFERENCE constraint")) == true)
{
intValue = -1;
}
}
return(intValue);
}
/// <summary>
/// Update records in CityMaster
/// </summary>
/// <param name="strCityName"></param>
/// <param name="strAbb"></param>
/// <param name="bStatus"></param>
/// <param name="intDistrictIdno"></param>
/// <param name="intStateIdno"></param>
/// <returns></returns>
public Int64 Update(string strDistrictName, string strDistrictNameHindi, string strAbb, Int64 intStateIdno, Int64 intDistrictIdno, bool bStatus, Int32 empIdno)
{
Int64 value = 0;
Int32 intCompIdno = 1;
using (TransportMandiEntities db = new TransportMandiEntities(MultipleDBDAL.strDynamicConString()))
{
tblDistrictMaster objMast = (from mast in db.tblDistrictMasters
where mast.District_Idno == intDistrictIdno
select mast).FirstOrDefault();
if (objMast != null)
{
objMast.District_Name = strDistrictName;
objMast.District_Abbr = strAbb;
objMast.Emp_Idno = empIdno;
objMast.District_Hindi = strDistrictNameHindi;
objMast.State_Idno = intStateIdno;
objMast.Status = bStatus;
objMast.Date_Modified = System.DateTime.Now;
if (IsExists(strDistrictName, intStateIdno, intDistrictIdno) == true)
{
value = -1;
}
else
{
db.SaveChanges();
value = intDistrictIdno;
}
}
}
return(value);
}