public Int64 Update(string strItemName, bool bStatus, Int64 intTyreIdno)
{
Int64 intValue = 0;
try
{
using (TransportMandiEntities db = new TransportMandiEntities(MultipleDBDAL.strDynamicConString()))
{
tblTyreTypeMaster objTyreMast = (from mast in db.tblTyreTypeMasters
where mast.TyreType_Idno == intTyreIdno
select mast).FirstOrDefault();
if (objTyreMast != null)
{
objTyreMast.TyreType_Name = strItemName;
objTyreMast.TyreType_Status = bStatus;
objTyreMast.Date_modified = System.DateTime.Now;
if (IsExists(strItemName, intTyreIdno) == true)
{
intValue = -1;
}
else
{
db.SaveChanges();
intValue = intTyreIdno;
}
}
}
}
catch (Exception ex)
{
//ApplicationFunction.ErrorLog(ex.ToString());
}
return(intValue);
}
public Int64 Insert(string strItemName, bool bStatus)
{
Int64 intValue = 0;
try
{
using (TransportMandiEntities db = new TransportMandiEntities(MultipleDBDAL.strDynamicConString()))
{
tblTyreTypeMaster ObjTyreMast = new tblTyreTypeMaster();
ObjTyreMast.TyreType_Name = strItemName;
ObjTyreMast.TyreType_Status = bStatus;
ObjTyreMast.Date_Added = System.DateTime.Now;
if (IsExists(strItemName, 0) == true)
{
intValue = -1;
}
else
{
db.tblTyreTypeMasters.AddObject(ObjTyreMast);
db.SaveChanges();
intValue = ObjTyreMast.TyreType_Idno;
}
}
}
catch (Exception ex)
{
//ApplicationFunction.ErrorLog(ex.ToString());
}
return(intValue);
}
public bool IsExists(string strItemName, Int64 intItemIdno)
{
using (TransportMandiEntities db = new TransportMandiEntities(MultipleDBDAL.strDynamicConString()))
{
tblTyreTypeMaster objTyreMast = new tblTyreTypeMaster();
if (intItemIdno <= 0)
{
objTyreMast = (from mast in db.tblTyreTypeMasters
where mast.TyreType_Name == strItemName
select mast).FirstOrDefault();
}
else if (intItemIdno > 0)
{
objTyreMast = (from mast in db.tblTyreTypeMasters
where mast.TyreType_Name == strItemName &&
mast.TyreType_Idno != intItemIdno
select mast).FirstOrDefault();
}
if (objTyreMast != null)
{
return(true);
}
else
{
return(false);
}
}
}
public Int32 UpdateStatus(int intItemIdno, bool Status)
{
int value = 0;
try
{
using (TransportMandiEntities db = new TransportMandiEntities(MultipleDBDAL.strDynamicConString()))
{
tblTyreTypeMaster objItemMast = (from mast in db.tblTyreTypeMasters
where mast.TyreType_Idno == intItemIdno
select mast).FirstOrDefault();
if (objItemMast != null)
{
objItemMast.TyreType_Status = Status;
objItemMast.Date_modified = System.DateTime.Now;
db.SaveChanges();
value = 1;
}
}
}
catch (Exception ex)
{
}
return(value);
}
public int Delete(int intTyreIdno)
{
int intValue = 0;
try
{
using (TransportMandiEntities db = new TransportMandiEntities(MultipleDBDAL.strDynamicConString()))
{
tblTyreTypeMaster objTyreMast = (from mast in db.tblTyreTypeMasters
where mast.TyreType_Idno == intTyreIdno
select mast).FirstOrDefault();
if (objTyreMast != null)
{
db.tblTyreTypeMasters.DeleteObject(objTyreMast);
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);
}
