public frmAddEditCreatureDiet(CreatureDietManager creatureDMgr, CreatureDiet creatureDiet, CreatureDietForm type)
{
this._creatureDietManager = creatureDMgr;
this._type = type;
this._creatureDiet = creatureDiet;
InitializeComponent();
}
private void performEdit()
{
if (validateInputs())
{
var diet = new CreatureDiet()
{
CreatureDietID = txtCreatureDiet.Text
};
try
{
int result = _creatureDietManager.UpdateCreatureDiet(_creatureDiet, diet);
if (result != 1)
{
throw new ApplicationException("Creature Diet was not updated!");
}
MessageBox.Show("Creature Diet was updated!");
this.DialogResult = true;
this.Close();
}
catch (Exception ex)
{
var message = ex.Message;
if (ex.InnerException != null)
{
message += "\n\n" + ex.InnerException.Message;
}
//have to display the error
MessageBox.Show(message, "Update Failed", MessageBoxButton.OK, MessageBoxImage.Exclamation);
}
}
}
public static int UpdateCreatureDiet(CreatureDiet oldCreatureDiet, CreatureDiet newCreatureDiet)
{
int result = 0;
var conn = DBConnection.GetDBConnection();
var cmdText = @"sp_update_creature_diet";
var cmd = new SqlCommand(cmdText, conn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@OldCreatureDietID", oldCreatureDiet.CreatureDietID);
cmd.Parameters.AddWithValue("@NewCreatureDietID", newCreatureDiet.CreatureDietID);
try
{
conn.Open();
result = cmd.ExecuteNonQuery();
}
catch (Exception)
{
throw;
}
finally
{
conn.Close();
}
return(result);
}
public static List <CreatureDiet> RetrieveCreatureDietListActive()
{
var creatureDiets = new List <CreatureDiet>();
//connect
var conn = DBConnection.GetDBConnection();
// command text
var cmdText = @"sp_retrieve_creatures_diet_active";
//command
var cmd = new SqlCommand(cmdText, conn);
cmd.CommandType = CommandType.StoredProcedure;
try
{
//open the connection
conn.Open();
//execute the command
var reader = cmd.ExecuteReader();
// check for return rows
if (reader.HasRows)
{
while (reader.Read())
{
var diet = new CreatureDiet()
{
CreatureDietID = reader.GetString(0),
Active = reader.GetBoolean(1)
};
creatureDiets.Add(diet);
}
}
}
catch (Exception)
{
throw;
}
finally
{
conn.Close();
}
return(creatureDiets);
}
public int AddCreatureDiet(CreatureDiet creatureDiet)
{
int result = 0;
try
{
result = CreatureDietAccessor.AddCreatureDiet(creatureDiet);
}
catch (Exception)
{
throw;
}
return(result);
}
public int UpdateCreatureDiet(CreatureDiet oldCreatureDiet, CreatureDiet newCreatureDiet)
{
int result = 0;
try
{
result = CreatureDietAccessor.UpdateCreatureDiet(oldCreatureDiet, newCreatureDiet);
}
catch (Exception)
{
throw;
}
return(result);
}
public CreatureDiet RetreiveCreatureDietByID(string id)
{
CreatureDiet diet = null;
try
{
diet = CreatureDietAccessor.RetreiveCreatureDietByID(id);
}
catch (Exception)
{
throw;
}
return(diet);
}
public static CreatureDiet RetreiveCreatureDietByID(string id)
{
CreatureDiet creatureDiet = null;
//connect
var conn = DBConnection.GetDBConnection();
// command text
var cmdText = @"sp_retrieve_creatures_diet_by_id";
//command
var cmd = new SqlCommand(cmdText, conn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@CreatureDietID", id);
try
{
//open the connection
conn.Open();
//execute the command
var reader = cmd.ExecuteReader();
// check for return rows
if (reader.HasRows)
{
reader.Read();
creatureDiet = new CreatureDiet()
{
CreatureDietID = reader.GetString(0),
Active = reader.GetBoolean(1)
};
}
}
catch (Exception)
{
throw;
}
finally
{
conn.Close();
}
return(creatureDiet);
}
// GET: CreatureDiet/Delete/5
public ActionResult Delete(string id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
try
{
CreatureDiet diet = _creatureDietManager.RetreiveCreatureDietByID(id);
CreatureDietViewModel creatureDietViewModel = new CreatureDietViewModel
{
DisplayCreatureDietID = diet.CreatureDietID,
Active = diet.Active
};
return(View(creatureDietViewModel));
}
catch (Exception ex)
{
return(RedirectToAction("Index", "Error", new { message = ex.Message, stackTrace = ex.StackTrace }));
}
}