public bool AddDepartment(ItemDepartmentObject itemDepartment)
{
SqlParameter[] params_ = new SqlParameter[] {
new SqlParameter("@Name", itemDepartment.Name),
new SqlParameter("@Description", itemDepartment.Description),
new SqlParameter("@IsActive", itemDepartment.IsActive),
new SqlParameter("@AddedBy", itemDepartment.AddedBy),
new SqlParameter("@DateAdded", itemDepartment.DateAdded),
new SqlParameter("@IP", Helpers.CustomHelper.GetLocalIPAddress()),
new SqlParameter("@MAC", Helpers.CustomHelper.GetMACAddress())
};
return(Library.ConnectionString.returnCon.executeQuery("spAddDepartment", params_, CommandType.StoredProcedure));
}
public bool ActivateDepartment(ItemDepartmentObject itemdepartment)
{
SqlParameter[] params_ = new SqlParameter[] {
new SqlParameter("@id", itemdepartment.Id),
new SqlParameter("@Code", itemdepartment.Code),
new SqlParameter("@table", "tblItemDepartmentRelationship"),
new SqlParameter("@IP", Helpers.CustomHelper.GetLocalIPAddress()),
new SqlParameter("@MAC", Helpers.CustomHelper.GetMACAddress()),
new SqlParameter("@Module", "ITEM"),
new SqlParameter("@AddedBy", itemdepartment.AddedBy),
new SqlParameter("@DateAdded", itemdepartment.DateAdded)
};
return(Library.ConnectionString.returnCon.executeQuery("spActivateItem", params_, CommandType.StoredProcedure));
}
