/// <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 } } }