public Result UpdateEmployee(WCFTransactionEntity employeeData) { var result = new Result() { IsValid = false }; StoreProcedureCommand procedure = CreateProcedureCommand("dbo.UpdateEmployee"); procedure.AppendGuid("EmpID", employeeData.EmpID); procedure.AppendNVarChar("Address", employeeData.Address); procedure.AppendNVarChar("EMail", employeeData.EMail); procedure.AppendNVarChar("Phone", employeeData.Phone); int resultValue = ExecuteCommand(procedure); if (resultValue == 0) { result.IsValid = true; result.Message = new List <string> { "Employee updated successfully" }; } return(result); }
/// <summary> /// Here exception is catched but not killed as it throw FaultException /// </summary> /// <param name="employeeData"></param> /// <returns></returns> public Result AddEmployee(WCFTransactionEntity employeeData) { Result result = new Result(); try { var buisnessLayer = BLFactory.CreateWCFTransactionEmployeeDemoBL(); result = buisnessLayer.AddEmployee(employeeData); } catch (Exception ex) { throw new FaultException <Result>(result); } return(result); }
protected void Employee_RowUpdating(object sender, GridViewUpdateEventArgs e) { var employeeID = new Guid(e.Keys[0].ToString()); TextBox Address = (TextBox)Employee.Rows[e.RowIndex].FindControl("txtAddress"); TextBox EMail = (TextBox)Employee.Rows[e.RowIndex].FindControl("txtEMail"); TextBox Phone = (TextBox)Employee.Rows[e.RowIndex].FindControl("txtPhone"); var emp = new WCFTransactionEntity { EmpID = employeeID, Address = Address.Text, EMail = EMail.Text, Phone = Phone.Text }; var service = new AF.Transaction.Sample.TransactionService.WCFTransactionDemoClient(); var result = service.UpdateEmployee(emp); Employee.EditIndex = -1; Session["employee"] = null; BindEmployeeGrid(); }
/// <summary> /// Here exception is catched & killed /// The return object contain bool property 'IsValid' /// The property set to false in catch; hence transaction would rollback /// </summary> /// <param name="employeeData"></param> /// <returns></returns> public Result UpdateEmployee(WCFTransactionEntity employeeData) { Result result = new Result(); try { var buisnessLayer = BLFactory.CreateWCFTransactionEmployeeDemoBL(); result = buisnessLayer.UpdateEmployee(employeeData); } catch (Exception ex) { result = new Result { IsValid = false, Message = new List <String> { "Error in update operation" } }; } return(result); }
protected void btnSubmit_Click(object sender, EventArgs e) { var employeeEntity = new WCFTransactionEntity(); employeeEntity.EmpID = Guid.NewGuid(); employeeEntity.Name = txtName.Text; employeeEntity.Address = txtAddress.Text; employeeEntity.Phone = txtPhone.Text; employeeEntity.EMail = txtEMail.Text; try { var service = new AF.Transaction.Sample.TransactionService.WCFTransactionDemoClient(); var result = service.AddEmployee(employeeEntity); Session["employee"] = null; BindEmployeeGrid(); if (result.IsValid) { lblMessage.ForeColor = Color.Black; txtName.Text = String.Empty; txtAddress.Text = String.Empty; txtPhone.Text = String.Empty; txtEMail.Text = String.Empty; lblMessage.Text = "Record added successfuly"; } else { lblMessage.ForeColor = Color.Red; foreach (var msg in result.Message) { lblMessage.Text = msg + "<br/>"; } } } catch (Exception ex) { //Log Error } }
public Result UpdateEmployee(WCFTransactionEntity employeeData) { var data = DataFactory.CreateWCFTransactionEmployeeDemoDL(); return(data.UpdateEmployee(employeeData)); }