public bool SaveIndustryCategory(IndustryCategory IndustryCategory) { DLLIndustryCategory industryCategory = new DLLIndustryCategory(); industryCategory.IndustryCategoryName = IndustryCategory.IndustryCategoryName; industryCategory.Status = IndustryCategory.Status; bool result = false; result = _IndustryCategory.SaveIndustryCategory(industryCategory); return(result); }
public bool UpdateIndustryCategory(DLLIndustryCategory IndustryCategory) { using (dbConnection) { string sqlQuery = "update [dbo].[IndustryCategory] SET IndustryCategoryName='" + IndustryCategory.IndustryCategoryName + "',Status='" + IndustryCategory.Status + "' WHERE IndustryCategoryId=" + IndustryCategory.IndustryCategoryId; rowsAffected = dbConnection.Execute(sqlQuery); } if (rowsAffected > 0) { return(true); } else { return(false); } }
public bool SaveIndustryCategory(DLLIndustryCategory IndustryCategory) { //Dapper Implementation try { con = connManager.GetConnection(); con.Open(); con.Execute(addNewIndustry, IndustryCategory, commandType: CommandType.StoredProcedure); con.Close(); return(true); } catch (Exception ex) { throw; } }