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