public Int64 Insert(string GradeName, string Abbr, bool bStatus)
{
Int64 intValue = 0;
try
{
using (TransportMandiEntities db = new TransportMandiEntities(MultipleDBDAL.strDynamicConString()))
{
tblGradeMaster obj = new tblGradeMaster();
obj.Grade_Name = GradeName;
obj.Grade_Abbr = Abbr;
obj.Status = bStatus;
obj.Date_Added = System.DateTime.Now;
if (IsExists(GradeName, 0) == true)
{
intValue = -1;
}
else
{
db.tblGradeMasters.AddObject(obj);
db.SaveChanges();
intValue = obj.Grade_Idno;
}
}
}
catch (Exception ex)
{
}
return(intValue);
}
public int Delete(int intGrdIdno)
{
int intValue = 0;
try
{
using (TransportMandiEntities db = new TransportMandiEntities(MultipleDBDAL.strDynamicConString()))
{
tblGradeMaster obj2 = (from mast in db.tblGradeMasters
where mast.Grade_Idno == intGrdIdno
select mast).FirstOrDefault();
if (obj2 != null)
{
db.tblGradeMasters.DeleteObject(obj2);
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);
}
public Int32 UpdateStatus(int intGrdIdno, bool Status)
{
int value = 0;
try
{
using (TransportMandiEntities db = new TransportMandiEntities(MultipleDBDAL.strDynamicConString()))
{
tblGradeMaster obj3 = (from mast in db.tblGradeMasters
where mast.Grade_Idno == intGrdIdno
select mast).FirstOrDefault();
if (obj3 != null)
{
obj3.Status = Status;
obj3.Date_Modified = System.DateTime.Now;
db.SaveChanges();
value = 1;
}
}
}
catch (Exception ex)
{
}
return(value);
}
public int Update(string GradeName, string Abrr, bool bStatus, int intGrdIdno)
{
int intValue = 0;
try
{
using (TransportMandiEntities db = new TransportMandiEntities(MultipleDBDAL.strDynamicConString()))
{
tblGradeMaster obj1 = (from mast in db.tblGradeMasters
where mast.Grade_Idno == intGrdIdno
select mast).FirstOrDefault();
if (obj1 != null)
{
obj1.Grade_Name = GradeName;
obj1.Grade_Abbr = Abrr;
obj1.Status = bStatus;
obj1.Date_Modified = System.DateTime.Now;
if (IsExists(GradeName, intGrdIdno) == true)
{
intValue = -1;
}
else
{
db.SaveChanges();
intValue = intGrdIdno;
}
}
}
}
catch (Exception ex)
{
}
return(intValue);
}
