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