/// <summary> /// Insert records in tblIGrpMast /// </summary> /// <param name="strIGroupName"></param> /// <param name="intIGrpType"></param> /// <param name="bStatus"></param> /// <returns></returns> public Int64 Insert(string strConSize, bool bStatus, Int32 empIdno) { Int64 intValue = 0; try { using (TransportMandiEntities db = new TransportMandiEntities(MultipleDBDAL.strDynamicConString())) { tblContainerSize objConSizeMast = new tblContainerSize(); objConSizeMast.Emp_Idno = empIdno; objConSizeMast.Container_Size = strConSize; objConSizeMast.Status = bStatus; objConSizeMast.Date_Added = System.DateTime.Now; if (IsExists(strConSize, 0) == true) { intValue = -1; } else { db.tblContainerSizes.AddObject(objConSizeMast); db.SaveChanges(); intValue = objConSizeMast.ContainerSize_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 strConSize, int intConSizeIdno) { using (TransportMandiEntities db = new TransportMandiEntities(MultipleDBDAL.strDynamicConString())) { tblContainerSize objConSizeMast = new tblContainerSize(); if (intConSizeIdno <= 0) { objConSizeMast = (from mast in db.tblContainerSizes where mast.Container_Size == strConSize select mast).FirstOrDefault(); } else if (intConSizeIdno > 0) { objConSizeMast = (from mast in db.tblContainerSizes where mast.Container_Size == strConSize && mast.ContainerSize_Idno != intConSizeIdno select mast).FirstOrDefault(); } if (objConSizeMast != null) { return(true); } else { return(false); } } }
/// <summary> /// Delete Record from tblIGrpMast /// </summary> /// <param name="intIGropIdno"></param> /// <returns></returns> public int Delete(int intConSizeIdno) { int intValue = 0; try { using (TransportMandiEntities db = new TransportMandiEntities(MultipleDBDAL.strDynamicConString())) { tblContainerSize objConSizeMast = (from mast in db.tblContainerSizes where mast.ContainerSize_Idno == intConSizeIdno select mast).FirstOrDefault(); if (objConSizeMast != null) { db.tblContainerSizes.DeleteObject(objConSizeMast); 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 intConSizeIdno, bool Status, Int32 empIdno) { int value = 0; try { using (TransportMandiEntities db = new TransportMandiEntities(MultipleDBDAL.strDynamicConString())) { tblContainerSize objConSizeMast = (from mast in db.tblContainerSizes where mast.ContainerSize_Idno == intConSizeIdno select mast).FirstOrDefault(); if (objConSizeMast != null) { objConSizeMast.Emp_Idno = empIdno; objConSizeMast.Status = Status; objConSizeMast.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 strConSize, bool bStatus, int intConSizeIdno, Int32 empIdno) { int intValue = 0; try { using (TransportMandiEntities db = new TransportMandiEntities(MultipleDBDAL.strDynamicConString())) { tblContainerSize objConSizeMast = (from mast in db.tblContainerSizes where mast.ContainerSize_Idno == intConSizeIdno select mast).FirstOrDefault(); if (objConSizeMast != null) { objConSizeMast.Emp_Idno = empIdno; objConSizeMast.Container_Size = strConSize; objConSizeMast.Status = bStatus; objConSizeMast.Date_Modified = System.DateTime.Now; if (IsExists(strConSize, intConSizeIdno) == true) { intValue = -1; } else { db.SaveChanges(); intValue = intConSizeIdno; } } } } catch (Exception ex) { //ApplicationFunction.ErrorLog(ex.ToString()); } return(intValue); }