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