public int addBGCAdministrator(IBGCAdministratorBO obj)
{
int ret = 0;
IBGCAdministratorDAL objbgcadmindal = ERecruitmentDALFactory.BGCAdministratorDALFactory.createBGCAdministratorDAL();
objbgcadmindal.addBGCAdministrator(obj);
return(ret);
}
protected void Add_Click(object sender, EventArgs e)
{
IBGCAdministratorBO objbgcadminbo = ERecruitmentFactoryBO.BGC_AdministratorBOFactory.createBGCAdministratorBO();
try
{
objbgcadminbo.Status = ddlApproval.SelectedValue;
objbgcadminbo.Status_Change_Date = DateTime.Now;
objbgcadminbo.Employee_Id = int.Parse(ddlBGCta.SelectedValue);
IBGCAdministratorBLL objbgcadminbll = ERecruitmentFactoryBLL.BGCAdministratorBLLFactory.createBGCAdministratorBLL();
objbgcadminbll.addBGCAdministrator(objbgcadminbo);
}
catch
{
throw;
}
}
public int addBGCAdministrator(IBGCAdministratorBO obj)
{
int ret = 0;
string sqlstr = "Data Source=inchnilpdb02;Initial Catalog=CHN22_MMS104_Group3;Persist Security Info=True;User ID=mms104group3;password=mms104group3";
SqlConnection con = new SqlConnection(sqlstr);
con.Open();
SqlCommand cmd = new SqlCommand();
cmd.Connection = con;
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "sp_select_bgcta";
cmd.Parameters.AddWithValue("@status", obj.Status);
cmd.Parameters.AddWithValue("@statusChangeDate", obj.Status_Change_Date);
cmd.Parameters.AddWithValue("@EmployeeID", obj.Employee_Id);
cmd.Parameters.AddWithValue("@BGC_Administrator_ID", 0);
cmd.Parameters["@BGC_Administrator_ID"].Direction = ParameterDirection.Output;
cmd.ExecuteNonQuery();
con.Close();
return(ret);
}
