/// <summary> /// Insert records in tblIGrpMast /// </summary> /// <param name="strIGroupName"></param> /// <param name="intIGrpType"></param> /// <param name="bStatus"></param> /// <returns></returns> public Int64 Insert(string CategoryName, bool bStatus, Int32 empIdno) { Int64 intValue = 0; try { using (TransportMandiEntities db = new TransportMandiEntities(MultipleDBDAL.strDynamicConString())) { tblCategoryMast objCategoryMast = new tblCategoryMast(); objCategoryMast.Emp_Idno = empIdno; objCategoryMast.Category_Name = CategoryName; objCategoryMast.Status = bStatus; objCategoryMast.Date_Added = System.DateTime.Now; if (IsExists(CategoryName, 0) == true) { intValue = -1; } else { db.tblCategoryMasts.AddObject(objCategoryMast); db.SaveChanges(); intValue = objCategoryMast.Category_Idno; } } } catch (Exception ex) { //ApplicationFunction.ErrorLog(ex.ToString()); } return(intValue); }
/// <summary> /// To Check data Already Exist or Not /// </summary> /// <param name="strIGroupName"></param> /// <param name="intIGropIdno"></param> /// <returns></returns> public bool IsExists(string categoryName, int intCategoryIdno) { using (TransportMandiEntities db = new TransportMandiEntities(MultipleDBDAL.strDynamicConString())) { tblCategoryMast objCategoryMast = new tblCategoryMast(); if (intCategoryIdno <= 0) { objCategoryMast = (from mast in db.tblCategoryMasts where mast.Category_Name == categoryName select mast).FirstOrDefault(); } else if (intCategoryIdno > 0) { objCategoryMast = (from mast in db.tblCategoryMasts where mast.Category_Name == categoryName && mast.Category_Idno != intCategoryIdno select mast).FirstOrDefault(); } if (objCategoryMast != null) { return(true); } else { return(false); } } }
/// <summary> /// Delete Record from tblIGrpMast /// </summary> /// <param name="intIGropIdno"></param> /// <returns></returns> public int Delete(int intCategoryIdno) { int intValue = 0; try { using (TransportMandiEntities db = new TransportMandiEntities(MultipleDBDAL.strDynamicConString())) { tblCategoryMast objCategoryMast = (from mast in db.tblCategoryMasts where mast.Category_Idno == intCategoryIdno select mast).FirstOrDefault(); if (objCategoryMast != null) { db.tblCategoryMasts.DeleteObject(objCategoryMast); 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 intCategoryIdno, bool Status, Int32 empIdno) { int value = 0; try { using (TransportMandiEntities db = new TransportMandiEntities(MultipleDBDAL.strDynamicConString())) { tblCategoryMast objCategoryMast = (from mast in db.tblCategoryMasts where mast.Category_Idno == intCategoryIdno select mast).FirstOrDefault(); if (objCategoryMast != null) { objCategoryMast.Emp_Idno = empIdno; objCategoryMast.Status = Status; objCategoryMast.Date_Modified = System.DateTime.Now; db.SaveChanges(); value = 1; } } } catch (Exception ex) { } return(value); }
/// <summary> /// To Update Record in tblIGrpMast /// </summary> /// <param name="strIGroupName"></param> /// <param name="intIGrpType"></param> /// <param name="bStatus"></param> /// <param name="intIGropIdno"></param> /// <returns></returns> public int Update(string CategoryName, bool bStatus, int intCategoryIdno, Int32 empIdno) { int intValue = 0; try { using (TransportMandiEntities db = new TransportMandiEntities(MultipleDBDAL.strDynamicConString())) { tblCategoryMast objCategoryMast = (from mast in db.tblCategoryMasts where mast.Category_Idno == intCategoryIdno select mast).FirstOrDefault(); if (objCategoryMast != null) { objCategoryMast.Emp_Idno = empIdno; objCategoryMast.Category_Name = CategoryName; objCategoryMast.Status = bStatus; objCategoryMast.Date_Modified = System.DateTime.Now; if (IsExists(CategoryName, intCategoryIdno) == true) { intValue = -1; } else { db.SaveChanges(); intValue = intCategoryIdno; } } } } catch (Exception ex) { //ApplicationFunction.ErrorLog(ex.ToString()); } return(intValue); }