public bool AddMeasure(UnitMeasureObject itemMeasure) { SqlParameter[] params_ = new SqlParameter[] { new SqlParameter("@Name", itemMeasure.Name), new SqlParameter("@Description", itemMeasure.Description), new SqlParameter("@IsActive", itemMeasure.IsActive), new SqlParameter("@AddedBy", itemMeasure.AddedBy), new SqlParameter("@DateAdded", itemMeasure.DateAdded), new SqlParameter("@IP", Helpers.CustomHelper.GetLocalIPAddress()), new SqlParameter("@MAC", Helpers.CustomHelper.GetMACAddress()) }; return(Library.ConnectionString.returnCon.executeQuery("spAddMeasureItem", params_, CommandType.StoredProcedure)); }
public bool ActivateMeasure(UnitMeasureObject itemmeasure) { SqlParameter[] params_ = new SqlParameter[] { new SqlParameter("@id", itemmeasure.Id), new SqlParameter("@Code", itemmeasure.Code), new SqlParameter("@table", "tblUnitOfMeasure"), new SqlParameter("@IP", Helpers.CustomHelper.GetLocalIPAddress()), new SqlParameter("@MAC", Helpers.CustomHelper.GetMACAddress()), new SqlParameter("@Module", "ITEM"), new SqlParameter("@AddedBy", itemmeasure.AddedBy), new SqlParameter("@DateAdded", itemmeasure.DateAdded) }; return(Library.ConnectionString.returnCon.executeQuery("spActivateItem", params_, CommandType.StoredProcedure)); }