public int InsertmProductSubCategory(mProductSubCategory prdSubCategory, string[] conn)
{
BISPL_CRMDBEntities ce = new BISPL_CRMDBEntities(svr.GetEntityConnection(conn));
ce.mProductSubCategories.AddObject(prdSubCategory);
ce.SaveChanges();
return(1);
}
public int updatemProductSubCategory(mProductSubCategory updateprdSubCategory, string[] conn)
{
BISPL_CRMDBEntities ce = new BISPL_CRMDBEntities(svr.GetEntityConnection(conn));
ce.mProductSubCategories.Attach(updateprdSubCategory);
ce.ObjectStateManager.ChangeObjectState(updateprdSubCategory, EntityState.Modified);
ce.SaveChanges();
return(1);
}
/// <summary>
/// GetProductSubCategoryListByID is providing List of ProductSubCategory By ID
/// </summary>
/// <returns></returns>
///
public mProductSubCategory GetProductSubCategoryListByID(int ProductSubCategoryId, string[] conn)
{
BISPL_CRMDBEntities ce = new BISPL_CRMDBEntities(svr.GetEntityConnection(conn));
mProductSubCategory PrdSubCategoryID = new mProductSubCategory();
PrdSubCategoryID = (from p in ce.mProductSubCategories
where p.ID == ProductSubCategoryId
select p).FirstOrDefault();
ce.Detach(PrdSubCategoryID);
return(PrdSubCategoryID);
}
