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); }