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);
}
