public ActionResult Put(IEnumerable<Provider> provider)
{
string toBeVoiced = string.Empty;
try
{
foreach (var prov in provider)
{
ProviderList newProvider = new ProviderList();
newProvider.ProviderID = prov.ProviderID;
newProvider.ProviderName = prov.ProviderName;
newProvider.Department = prov.Department;
providers.AddProvider(newProvider);
}
return new JsonResult { Data = new { Success = true } };
}
catch (Exception er)
{
string s1 = er.Message;
return new JsonResult { Data = new { Success = false } };
}
}
public void DeleteProvider(ProviderList providerList)
{
using (MySqlConnection db = new MySqlConnection(Database.ReminderConnection))
{
try
{
string query =
"delete from providers"
+ " where id = @id";
int rowsAffectd = db.Execute(query, new
{
@id = providerList.ID
}
);
}
catch (Exception er)
{
Log.LogMessage(er.ToString());
}
}
}
public void UpdateProvider(ProviderList providerList)
{
string providerID = string.Empty;
string providerName = string.Empty;
string department = string.Empty;
try
{
if (String.IsNullOrEmpty(providerList.ProviderID))
{
providerID = string.Empty;
}
else
{
providerID = providerList.ProviderID;
}
}
catch
{
providerID = string.Empty;
}
try
{
if (String.IsNullOrEmpty(providerList.ProviderName))
{
providerName = string.Empty;
}
else
{
providerName = providerList.ProviderName;
}
}
catch
{
providerName = string.Empty;
}
try
{
if (String.IsNullOrEmpty(providerList.Department))
{
department = string.Empty;
}
else
{
department = providerList.Department;
}
}
catch
{
department = string.Empty;
}
using (MySqlConnection db = new MySqlConnection(Database.ReminderConnection))
{
try
{
string query =
"update providers"
+ " set providerID = @providerID"
+ " , providerName = @providerName"
+ " , department = @department"
+ " where id = @ID";
int rowsAffectd = db.Execute(query, new
{
@providerID = providerID,
@providerName = providerName,
@department = department,
@ID = providerList.ID
}
);
}
catch (Exception er)
{
Log.LogMessage(er.ToString());
}
}
}
public void AddProvider(ProviderList providerList)
{
using (MySqlConnection db = new MySqlConnection(Database.ReminderConnection))
{
try
{
string query =
"insert into providers(providerID,providerName,department)"
+ "values(@providerID,@providerName,@department)";
int rowsAffectd = db.Execute(query, new
{
@providerID = providerList.ProviderID,
@providerName = providerList.ProviderName,
@department = providerList.Department
}
);
}
catch (Exception er)
{
Log.LogMessage(er.ToString());
}
}
}