/// <summary>
/// rGridAddress_DeleteCommand - Is executed if the 'Delete' command is called
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void rGridAddress_DeleteCommand(object sender, GridCommandEventArgs e)
{
GridEditableItem eeditedItem = e.Item as GridEditableItem;
sp_Sample_Address_Select_DM cSampleAddress = new sp_Sample_Address_Select_DM();
cSampleAddress.AddrID = Convert.ToInt32(eeditedItem.OwnerTableView.DataKeyValues[eeditedItem.ItemIndex]["AddrID"]);
BLL.DeleteSampleAddressContext(cSampleAddress);
}
public void DeleteSampleAddressContext(sp_Sample_Address_Select_DM lSampleAddress)
{
using (VolTeerEntities context = new VolTeerEntities())
{
// Load the Address based on the AddrID
var AddressToRemove = (from n in context.tblSampleAddresses where n.AddrID == lSampleAddress.AddrID select n).FirstOrDefault();
context.tblSampleAddresses.Remove(AddressToRemove);
context.SaveChanges();
}
}
public void InsertSampleAddressContext(sp_Sample_Address_Select_DM lSampleAddress)
{
using (VolTeerEntities context = new VolTeerEntities())
{
var SampleAddress = new tblSampleAddress
{
AddrLine1 = lSampleAddress.AddrLine1,
AddrLine2 = lSampleAddress.AddrLine2,
AddrLine3 = lSampleAddress.AddrLine3,
City = lSampleAddress.City,
St = lSampleAddress.St,
Zip = lSampleAddress.Zip,
Zip4 = lSampleAddress.Zip4,
ActiveFlg = lSampleAddress.ActiveFlg
};
context.tblSampleAddresses.Add(SampleAddress);
context.SaveChanges();
}
}
/// <summary>
/// UpdateSampleAddressContext... pass in an object of SampleAddress... assign the object variables to the context variables, call the update
/// </summary>
/// <param name="lSampleAddress"></param>
public void UpdateSampleAddressContext(sp_Sample_Address_Select_DM lSampleAddress)
{
using (VolTeerEntities context = new VolTeerEntities())
{
// Load the Address based on the AddrID
var SampleAddress = context.tblSampleAddresses.Find(lSampleAddress.AddrID);
if (SampleAddress != null)
{
SampleAddress.AddrLine1 = lSampleAddress.AddrLine1;
SampleAddress.AddrLine2 = lSampleAddress.AddrLine2;
SampleAddress.AddrLine3 = lSampleAddress.AddrLine3;
SampleAddress.City = lSampleAddress.City;
SampleAddress.St = lSampleAddress.St;
SampleAddress.Zip = lSampleAddress.Zip;
SampleAddress.Zip4 = lSampleAddress.Zip4;
SampleAddress.ActiveFlg = lSampleAddress.ActiveFlg;
context.SaveChanges();
}
}
}
public void UpdateSampleAddressContext(sp_Sample_Address_Select_DM lSampleAddress)
{
DAL.UpdateSampleAddressContext(lSampleAddress);
}
public void InsertSampleAddressContext(sp_Sample_Address_Select_DM lSampleAddress)
{
DAL.InsertSampleAddressContext(lSampleAddress);
}
/// <summary>
/// rGridAdress_UpdIns - Call this shared method if insert or update
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
/// <param name="iAction"></param>
protected void rGridAdress_UpdIns(object sender, GridCommandEventArgs e, int iAction)
{
GridEditableItem eeditedItem = e.Item as GridEditableItem;
sp_Sample_Address_Select_DM cSampleAddress = new sp_Sample_Address_Select_DM();
if (iAction == (int)RecordAction.Update)
{
cSampleAddress.AddrID = Convert.ToInt32(eeditedItem.OwnerTableView.DataKeyValues[eeditedItem.ItemIndex]["AddrID"]);
}
else if (iAction == (int)RecordAction.Insert)
{
cSampleAddress.AddrID = 0;
}
cSampleAddress.AddrLine1 = (eeditedItem.FindControl("rTXTAddrLine1") as RadTextBox).Text.ToString();
cSampleAddress.AddrLine2 = (eeditedItem.FindControl("rTXTAddrLine2") as RadTextBox).Text.ToString();
cSampleAddress.AddrLine3 = (eeditedItem.FindControl("rTXTAddrLine3") as RadTextBox).Text.ToString();
cSampleAddress.City = (eeditedItem.FindControl("rTXTCity") as RadTextBox).Text.ToString();
RadDropDownList rddSt = (RadDropDownList)eeditedItem.FindControl("rDDState");
cSampleAddress.St = rddSt.SelectedValue.ToString();
cSampleAddress.Zip = Convert.ToInt32((eeditedItem.FindControl("rMTZip") as RadMaskedTextBox).Text);
string strZip4 = ((eeditedItem.FindControl("rMTZip4") as RadMaskedTextBox).Text).ToString();
if (strZip4 == string.Empty)
{
cSampleAddress.Zip4 = null;
}
else
{
cSampleAddress.Zip4 = Convert.ToInt32(strZip4.ToString());
}
if (iAction == (int)RecordAction.Update)
{
cSampleAddress.ActiveFlg = (eeditedItem.FindControl("chkActiveUpd") as CheckBox).Checked;
try
{
BLL.UpdateSampleAddressContext(cSampleAddress);
}
catch (SqlException sex)
{
//TODO: Implement error page to display SQL Exception errors
}
catch (Exception ex)
{
//TODO: Implement error page to display SQL Exception errors
}
}
else if (iAction == (int)RecordAction.Insert)
{
cSampleAddress.ActiveFlg = (eeditedItem.FindControl("chkActiveIns") as CheckBox).Checked;
try
{
BLL.InsertSampleAddressContext(cSampleAddress);
}
catch (SqlException sex)
{
//TODO: Implement error page to display SQL Exception errors
}
catch (Exception ex)
{
//TODO: Implement error page to display SQL Exception errors
}
}
}