protected void gvRecAgency_RowCommand(object sender, GridViewCommandEventArgs e)
{
int id = Convert.ToInt32(e.CommandArgument);
string cmdName = e.CommandName;
if (cmdName.Equals("cmdDelete"))
{
// Perform Delete Operation
TRNRecruitmentAgency RecAgencyID = new TRNRecruitmentAgency();
RecAgencyID.RecAgencyID = id;
RecAgencyID.ModifiedBy = 1;
RecAgencyID.Status = 0;
int result = new TRNRecruitmentAgencyBO().DeleteRecruitmentAgency(RecAgencyID);
LoadRecruitmentAgency();
}
if (cmdName.Equals("cmdEdit"))
{
// Show data to TextBoxes and controls
DataView dvRecord = new TRNRecruitmentAgencyBO().GetRecruitmentAgencyByID(id);
if (dvRecord.Count > 0)
{
lblID.Text = dvRecord.Table.Rows[0]["ID"].ToString();
txtRecruitmentAgency.Text = dvRecord.Table.Rows[0]["RecruitmentAgency"].ToString();
btnSave.Text = "Save";
}
}
}
protected void btnSave_Click(object sender, EventArgs e)
{
if (lblID.Text != string.Empty)
{
TRNRecruitmentAgency RecAgencyUpdate = new TRNRecruitmentAgency();
RecAgencyUpdate.RecAgencyID = Convert.ToInt32(lblID.Text);
RecAgencyUpdate.RecruitmentAgency = txtRecruitmentAgency.Text;
RecAgencyUpdate.ModifiedBy = 1;
RecAgencyUpdate.Status = 1;
int result = new TRNRecruitmentAgencyBO().UpdateRecruitmentAgency(RecAgencyUpdate);
if (result > 0)
{
Clear();
btnSave.Text = "Save";
LoadRecruitmentAgency();
}
}
else
{
TRNRecruitmentAgency RecAgencyInsert = new TRNRecruitmentAgency();
RecAgencyInsert.RecruitmentAgency = txtRecruitmentAgency.Text;
RecAgencyInsert.CreatedBy = 1;
RecAgencyInsert.Status = 1;
int result = new TRNRecruitmentAgencyBO().InsertRecruitmentAgency(RecAgencyInsert);
if (result > 0)
{
Clear();
LoadRecruitmentAgency();
}
}
}
public int InsertRecruitmentAgency(TRNRecruitmentAgency objRec)
{
objRec.RecAgencyID = 1;
objRec.CreatedDate = DateTime.Now;
BeginTransaction();
try
{
objRec.RecAgencyID = Insert(objRec);
CommitTransaction();
}
catch (Exception ex)
{
RollBackTransaction();
objRec.RecAgencyID = -1;
}
return objRec.RecAgencyID;
}
public int DeleteRecruitmentAgency(TRNRecruitmentAgency objRec)
{
int rowsaffected = -1;
BeginTransaction();
try
{
String[] UpdateProperties = new String[] { "UpdatedBy","UpdatedDate","Status"};
rowsaffected = Update(objRec, UpdateProperties);
CommitTransaction();
}
catch (Exception e)
{
RollBackTransaction();
rowsaffected = -1;
}
return rowsaffected;
}
public int DeleteRecruitmentAgency(TRNRecruitmentAgency recAgency)
{
recAgency.ModifiedDate = DateTime.Now;
return new TRNRecruitmentAgencyDAO().DeleteRecruitmentAgency(recAgency);
}
public int InsertRecruitmentAgency(TRNRecruitmentAgency recAgency)
{
return new TRNRecruitmentAgencyDAO().InsertRecruitmentAgency(recAgency);
}
