protected void Update_Click(object sender, EventArgs e)
{
int id = 0;
if (string.IsNullOrEmpty(ID.Text))
{
errormsgs.Add("Search for a Player to update");
}
else if (!int.TryParse(ID.Text, out id))
{
errormsgs.Add("Id is invalid");
}
Validation(sender, e);
if (errormsgs.Count > 0)
{
LoadMessageDisplay(errormsgs, "alert alert-info");
}
else
{
try
{
Controller02 sysmgr = new Controller02();
Entity02 item = new Entity02();
item.PlayerID = int.Parse(ID.Text);
item.FirstName = FirstName.Text.Trim();
item.LastName = LastName.Text.Trim();
item.Gender = Gender.Text.ToUpper().Trim();
item.Age = int.Parse(Age.Text);
item.AlbertaHealthCareNumber = AlbertaHealthCareNumber.Text.Trim();
item.MedicalAlertDetails = MedicalAlertDetails.Text.Trim();
if (SupplierList.SelectedIndex == 0)
{
item.TeamID = null;
}
else
{
item.TeamID = int.Parse(SupplierList.SelectedValue);
}
item.GuardianID = int.Parse(CategoryList.SelectedValue);
int rowsaffected = sysmgr.Update(item);
if (rowsaffected > 0)
{
errormsgs.Add("Record has been updated");
LoadMessageDisplay(errormsgs, "alert alert-success");
}
else
{
errormsgs.Add("Record was not found");
LoadMessageDisplay(errormsgs, "alert alert-warning");
}
}
catch (Exception ex)
{
errormsgs.Add(GetInnerException(ex).ToString());
LoadMessageDisplay(errormsgs, "alert alert-danger");
}
}
}
protected void Update_Click(object sender, EventArgs e)
{
int id = 0;
if (string.IsNullOrEmpty(ID.Text))
{
errormsgs.Add("Search for a player to update");
}
else if (!int.TryParse(ID.Text, out id))
{
errormsgs.Add("Id is invalid");
}
Validation(sender, e);
if (errormsgs.Count > 0)
{
LoadMessageDisplay(errormsgs, "alert alert-info");
}
else
{
try
{
Controller02 sysmgr = new Controller02();
Entity02 player = new Entity02();
player.PlayerID = int.Parse(ID.Text);
player.FirstName = FirstName.Text;
player.LastName = LastName.Text;
player.GuardianID = int.Parse(GuardianList.SelectedValue);
player.TeamID = int.Parse(TeamList.SelectedValue);
player.Age = int.Parse(Age.Text);
player.Gender = Gender.Text.ToUpper();
player.AlbertaHealthCareNumber = AlbertaHealthCareNumber.Text;
if (string.IsNullOrEmpty(MedicalAlertDetails.Text))
{
player.MedicalAlertDetails = null;
}
else
{
player.MedicalAlertDetails = MedicalAlertDetails.Text;
}
//item.Discontinued = Discontinued.Checked;
int rowsaffected = sysmgr.Update(player);
if (rowsaffected > 0)
{
errormsgs.Add("Player has been updated");
LoadMessageDisplay(errormsgs, "alert alert-success");
}
else
{
errormsgs.Add("Player was not found");
LoadMessageDisplay(errormsgs, "alert alert-warning");
}
}
catch (Exception ex)
{
errormsgs.Add(GetInnerException(ex).ToString());
LoadMessageDisplay(errormsgs, "alert alert-danger");
}
}
}
protected void Update_Click(object sender, EventArgs e)
{
int id = 0;
if (string.IsNullOrEmpty(ID.Text))
{
errormsgs.Add("Search for a record to update");
}
else if (!int.TryParse(ID.Text, out id))
{
errormsgs.Add("Id is invalid");
}
Validation(sender, e);
if (errormsgs.Count > 1)
{
LoadMessageDisplay(errormsgs, "alert alert-info");
}
else
{
try
{
Controller02 sysmgr = new Controller02();
Entity02 item = new Entity02();
item.ProductID = int.Parse(ID.Text);
item.ProductName = Name.Text.Trim();
if (SupplierList.SelectedIndex == 0)
{
item.SupplierID = null;
}
else
{
item.SupplierID = int.Parse(SupplierList.SelectedValue);
}
item.CategoryID = int.Parse(CategoryList.SelectedValue);
item.QuantityPerUnit =
string.IsNullOrEmpty(QuantityPerUnit.Text) ? null : QuantityPerUnit.Text;
if (string.IsNullOrEmpty(UnitPrice.Text))
{
item.UnitPrice = null;
}
else
{
item.UnitPrice = decimal.Parse(UnitPrice.Text);
}
if (string.IsNullOrEmpty(UnitsInStock.Text))
{
item.UnitsInStock = null;
}
else
{
item.UnitsInStock = Int16.Parse(UnitsInStock.Text);
}
if (string.IsNullOrEmpty(UnitsOnOrder.Text))
{
item.UnitsOnOrder = null;
}
else
{
item.UnitsOnOrder = Int16.Parse(UnitsOnOrder.Text);
}
if (string.IsNullOrEmpty(ReorderLevel.Text))
{
item.ReorderLevel = null;
}
else
{
item.ReorderLevel = Int16.Parse(ReorderLevel.Text);
}
item.Discontinued = Discontinued.Checked;
int rowsaffected = sysmgr.Update(item);
if (rowsaffected > 0)
{
errormsgs.Add("Record has been updated");
LoadMessageDisplay(errormsgs, "alert alert-success");
}
else
{
errormsgs.Add("Record was not found");
LoadMessageDisplay(errormsgs, "alert alert-warning");
}
}
catch (Exception ex)
{
errormsgs.Add(GetInnerException(ex).ToString());
LoadMessageDisplay(errormsgs, "alert alert-danger");
}
}
}