protected void gvTrainingAgency_RowCommand(object sender, GridViewCommandEventArgs e) { if (e.CommandName.Equals("cmdDelete")) { TRNTrainingAgency AgencyDelete = new TRNTrainingAgency(); AgencyDelete.AgencyID = Convert.ToInt32(e.CommandArgument); AgencyDelete.Status = 0; int result = new TRNTrainingAgencyBO().DeleteTrainingAgency(AgencyDelete); LoadAgencyInforamtion(); } if (e.CommandName.Equals("cmdEdit")) { DataView dvRecord = new TRNTrainingAgencyBO().GetTrainingAgencyByID(Convert.ToInt32(e.CommandArgument)); if (dvRecord.Count > 0) { txtTrainingAgency.Text = dvRecord.Table.Rows[0]["TrainingAgency"].ToString(); txtAddress.Text = dvRecord.Table.Rows[0]["Address"].ToString(); txtPhone.Text = dvRecord.Table.Rows[0]["Phone"].ToString(); txtContactPerson.Text = dvRecord.Table.Rows[0]["ContactPerson"].ToString(); lblID.Text = dvRecord.Table.Rows[0]["ID"].ToString(); collapse = 0; btnSave.Text = "Update"; } LoadAgencyInforamtion(); } }
public int InsertTrainingAgency(TRNTrainingAgency objAgency) { objAgency.AgencyID = 1; objAgency.CreatedDate = DateTime.Now; BeginTransaction(); try { objAgency.AgencyID = Insert(objAgency); CommitTransaction(); } catch (Exception ex) { RollBackTransaction(); objAgency.AgencyID = -1; } return objAgency.AgencyID; }
protected void btnSave_Click(object sender, EventArgs e) { if (lblID.Text != "") { TRNTrainingAgency agencyUpdate = new TRNTrainingAgency(); agencyUpdate.TrainingAgency = txtTrainingAgency.Text; agencyUpdate.Address = txtAddress.Text; agencyUpdate.Phone = txtPhone.Text; agencyUpdate.ContactPerson = txtContactPerson.Text; agencyUpdate.ModifiedBy = 1; agencyUpdate.Status = 1; agencyUpdate.AgencyID = Convert.ToInt32(lblID.Text); result = new TRNTrainingAgencyBO().UpdateTrainingAgency(agencyUpdate); if (result > 0) { Clear(); btnSave.Text = "Save"; collapse = 1; LoadAgencyInforamtion(); } } else { TRNTrainingAgency agency = new TRNTrainingAgency(); agency.TrainingAgency = txtTrainingAgency.Text; agency.Address = txtAddress.Text; agency.Phone = txtPhone.Text; agency.ContactPerson = txtContactPerson.Text; agency.CreatedBy = 1; agency.Status = 1; result = new TRNTrainingAgencyBO().InsertTrainingAgency(agency); if (result > 0) { Clear(); collapse = 1; LoadAgencyInforamtion(); } } }
public int DeleteTrainingAgency(TRNTrainingAgency objAgency) { int rowsaffected = -1; BeginTransaction(); try { String[] UpdateProperties = new String[] { "Status" }; rowsaffected = Update(objAgency, UpdateProperties); CommitTransaction(); } catch (Exception e) { RollBackTransaction(); rowsaffected = -1; } return rowsaffected; }
public int UpdateTrainingAgency(TRNTrainingAgency objAgency) { int rowsaffected = -1; BeginTransaction(); try { String[] UpdateProperties = new String[] { "TrainingAgency","Address","Phone","ContactPerson","UpdatedBy","UpdatedDate","Status" }; rowsaffected = Update(objAgency, UpdateProperties); CommitTransaction(); } catch (Exception e) { RollBackTransaction(); rowsaffected = -1; } return rowsaffected; }
public int DeleteTrainingAgency(TRNTrainingAgency objAgency) { objAgency.ModifiedDate = DateTime.Now; return new TRNTrainingAgencyDAO().UpdateTrainingAgency(objAgency); }
public int InsertTrainingAgency(TRNTrainingAgency objAgency) { return new TRNTrainingAgencyDAO().InsertTrainingAgency(objAgency); }