public bool DeleteTriggerMaintenance_ByMaintenanceValue(DBSetting dbSetting, CategoryEnum category, ActionTypeEnum actionType, string maintenanceValue)
{
var TriggerMaintenanceList = TriggerMaintenanceRepo.Instance.GetTriggerMaintenance_ByMaintenanceValue(dbSetting, category, actionType, maintenanceValue.Replace("'", "''"));
var responseModel = new DBResponseModel();
if (TriggerMaintenanceList.Rows.Count != 0)
{
//Delete the record
responseModel = TriggerMaintenanceRepo.Instance.DeleteTriggerMaintenance_ByMaintenanceValue(dbSetting, category, maintenanceValue);
if (responseModel.Status == DBStatusCodeEnum.Success)
{
return(true);
}
else
{
// fail, insert into log
return(false);
}
}
else
{
return(true);
}
}
public DBResponseModel Execute(DBSetting dbSetting, string query, Dictionary <string, object> _params = null)
{
DBResponseModel response = new DBResponseModel();
using (SqlConnection conn = new SqlConnection(dbSetting.ConnectionString))
{
SqlCommand cmd = new SqlCommand();
try
{
cmd.Connection = conn;
cmd.CommandText = query;
cmd.Connection.Open();
if (_params.Count != 0)
{
foreach (var param in _params)
{
cmd.Parameters.AddWithValue(param.Key, param.Value);
}
}
cmd.ExecuteNonQuery();
response = new DBResponseModel
{
Status = DBStatusCodeEnum.Success
};
}
catch (Exception ex)
{
response = new DBResponseModel
{
Status = DBStatusCodeEnum.Fail,
Message = ex.Message.ToString(),
};
}
finally
{
cmd.Connection.Close();
}
}
return(response);
}
