public Int32 UpdateStatus(int intItemIdno, bool Status, Int32 EmpIdno) { int value = 0; try { using (TransportMandiEntities db = new TransportMandiEntities(MultipleDBDAL.strDynamicConString())) { ItemMast objItemMast = (from mast in db.ItemMasts where mast.Item_Idno == intItemIdno select mast).FirstOrDefault(); if (objItemMast != null) { objItemMast.Status = Status; objItemMast.Emp_Idno = EmpIdno; objItemMast.Date_modified = System.DateTime.Now; db.SaveChanges(); value = 1; } } } catch (Exception ex) { } return(value); }
/// <summary> /// Delete record from ItemMast /// </summary> /// <param name="intItemIdno"></param> /// <returns></returns> public int Delete(int intItemIdno) { int intValue = 0; try { using (TransportMandiEntities db = new TransportMandiEntities(MultipleDBDAL.strDynamicConString())) { ItemMast objItemMast = (from mast in db.ItemMasts where mast.Item_Idno == intItemIdno select mast).FirstOrDefault(); if (objItemMast != null) { db.ItemMasts.DeleteObject(objItemMast); 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); }
/// <summary> /// To check record existence in ItemMast /// </summary> /// <param name="strUOMName"></param> /// <param name="intItemIdno"></param> /// <returns></returns> public bool IsExists(string strItemName, Int64 intItemIdno) { using (TransportMandiEntities db = new TransportMandiEntities(MultipleDBDAL.strDynamicConString())) { ItemMast objItemMast = new ItemMast(); if (intItemIdno <= 0) { objItemMast = (from mast in db.ItemMasts where mast.Item_Name == strItemName select mast).FirstOrDefault(); } else if (intItemIdno > 0) { objItemMast = (from mast in db.ItemMasts where mast.Item_Name == strItemName && mast.Item_Idno != intItemIdno select mast).FirstOrDefault(); } if (objItemMast != null) { return(true); } else { return(false); } } }
/// <summary> /// Update records in ItemMast /// </summary> /// <param name="strUOMName"></param> /// <param name="strUOMDesc"></param> /// <param name="bStatus"></param> /// <param name="intUOMIdno"></param> /// <returns></returns> public Int64 Update(string strItemName, string strItemNameHindi, string strItemDesc, Int64 GrpType, Int64 ItemUnit, bool bStatus, Int64 intItemIdno, Int32 empIdno, string HSNSAC) { Int64 intValue = 0; try { using (TransportMandiEntities db = new TransportMandiEntities(MultipleDBDAL.strDynamicConString())) { ItemMast objItemMast = (from mast in db.ItemMasts where mast.Item_Idno == intItemIdno select mast).FirstOrDefault(); if (objItemMast != null) { objItemMast.Item_Name = strItemName; objItemMast.ItemNamel_Hindi = strItemNameHindi; objItemMast.Item_Desc = strItemDesc; objItemMast.Status = bStatus; objItemMast.IGrp_Idno = GrpType; objItemMast.Unit_Idno = ItemUnit; objItemMast.Emp_Idno = empIdno; objItemMast.HSNSAC_No = HSNSAC; objItemMast.Date_modified = System.DateTime.Now; if (IsExists(strItemName, intItemIdno) == true) { intValue = -1; } else { db.SaveChanges(); intValue = intItemIdno; } } } } catch (Exception ex) { //ApplicationFunction.ErrorLog(ex.ToString()); } return(intValue); }
/// <summary> /// Insert records in ItemMast /// </summary> /// <param name="strUOMName"></param> /// <param name="strItemDesc"></param> /// <param name="bStatus"></param> /// <returns></returns> public Int64 Insert(string strItemName, string strItemNameHindi, string strItemDesc, Int64 GrpType, Int64 ItemUnit, bool bStatus, Int32 empIdno, string HSNSAC) { Int64 intValue = 0; Int32 intCompIdno = 1; try { using (TransportMandiEntities db = new TransportMandiEntities(MultipleDBDAL.strDynamicConString())) { ItemMast objItemMast = new ItemMast(); objItemMast.Item_Name = strItemName; objItemMast.ItemNamel_Hindi = strItemNameHindi; objItemMast.Item_Desc = strItemDesc; objItemMast.Status = bStatus; objItemMast.IGrp_Idno = GrpType; objItemMast.Unit_Idno = ItemUnit; objItemMast.Comp_IdNo = intCompIdno; objItemMast.Emp_Idno = empIdno; objItemMast.HSNSAC_No = HSNSAC; objItemMast.Date_Added = System.DateTime.Now; if (IsExists(strItemName, 0) == true) { intValue = -1; } else { db.ItemMasts.AddObject(objItemMast); db.SaveChanges(); intValue = objItemMast.Item_Idno; } } } catch (Exception ex) { //ApplicationFunction.ErrorLog(ex.ToString()); } return(intValue); }