public Int64 Update(Int64 PositiIdno, string PositonName, bool Status)
{
Int64 value = 0;
try
{
using (TransportMandiEntities db = new TransportMandiEntities(MultipleDBDAL.strDynamicConString()))
{
tblPositionMast ObjPosit = db.tblPositionMasts.Where(r => r.Position_id == PositiIdno).FirstOrDefault();
if (ObjPosit != null)
{
ObjPosit.Position_name = PositonName;
ObjPosit.IsActive = Status;
value = ObjPosit.Position_id;
if (IsExists(PositonName, PositiIdno) == true)
{
value = -1;
}
else
{
db.SaveChanges();
value = PositiIdno;
}
}
}
}
catch (Exception ex)
{
}
return(value);
}
public bool IsExists(string PositonName, Int64 PositiIdno)
{
using (TransportMandiEntities db = new TransportMandiEntities(MultipleDBDAL.strDynamicConString()))
{
tblPositionMast ObjPosit = new tblPositionMast();
if (PositiIdno <= 0)
{
ObjPosit = (from mast in db.tblPositionMasts
where mast.Position_name == PositonName
select mast).FirstOrDefault();
}
else if (PositiIdno > 0)
{
ObjPosit = (from mast in db.tblPositionMasts
where mast.Position_name == PositonName &&
mast.Position_id != PositiIdno
select mast).FirstOrDefault();
}
if (ObjPosit != null)
{
return(true);
}
else
{
return(false);
}
}
}
public int Delete(Int64 PostionIdno)
{
int intValue = 0;
try
{
using (TransportMandiEntities db = new TransportMandiEntities(MultipleDBDAL.strDynamicConString()))
{
tblPositionMast objMast = (from mast in db.tblPositionMasts
where mast.Position_id == PostionIdno
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);
}
private void Populate(Int64 PositionIdno)
{
PositionMastDAL objPosit = new PositionMastDAL();
tblPositionMast objPositMast = objPosit.SelectById(PositionIdno);
objPosit = null;
if (objPositMast != null)
{
txtPostionName.Text = Convert.ToString(objPositMast.Position_name);
chkStatus.Checked = Convert.ToBoolean(objPositMast.IsActive);
hidPositionidno.Value = Convert.ToString(objPositMast.Position_id);
txtPostionName.Focus();
}
}
public Int64 Insert(string PositonName, bool Status)
{
Int64 value = 0;
using (TransportMandiEntities db = new TransportMandiEntities(MultipleDBDAL.strDynamicConString()))
{
int Exist = db.tblPositionMasts.Where(r => r.Position_name == PositonName).Count();
if (Exist == 0)
{
tblPositionMast ObjPosit = new tblPositionMast();
ObjPosit.Position_name = PositonName;
ObjPosit.IsActive = Status;
db.tblPositionMasts.AddObject(ObjPosit);
db.SaveChanges();
value = ObjPosit.Position_id;
}
else
{
value = -1;
}
}
return(value);
}
public Int32 UpdateStatus(Int64 PostionIdno, bool bStatus)
{
int value = 0;
try
{
using (TransportMandiEntities db = new TransportMandiEntities(MultipleDBDAL.strDynamicConString()))
{
tblPositionMast objPostionMast = (from mast in db.tblPositionMasts
where mast.Position_id == PostionIdno
select mast).FirstOrDefault();
if (objPostionMast != null)
{
objPostionMast.IsActive = bStatus;
db.SaveChanges();
value = 1;
}
}
}
catch (Exception ex)
{
}
return(value);
}
