public int updateBGCSchedule(IBGCScheduleBO obj)
{
int ret = 0;
IBGCScheduleDAL objbgcschdal = ERecruitmentDALFactory.BGCScheduleDALFactory.createBGCScheduleDAL();
return(ret);
}
protected void Schedule1_Click1(object sender, EventArgs e)
{
IBGCScheduleBO objbgcschedulebo = ERecruitmentFactoryBO.BGC_ScheduleBOFactory.createBGCScheduleBO();
try
{
objbgcschedulebo.From_Date = Convert.ToDateTime(txtfrom.Text);
objbgcschedulebo.To_Date = Convert.ToDateTime(txtto.Text);
objbgcschedulebo.Location = ddlLocation.SelectedValue;
objbgcschedulebo.Administrator_Id = Convert.ToInt32(ddlSchedule.SelectedValue);
IBGCScheduleBLL objbgcschedulebll = ERecruitmentFactoryBLL.BGCScheduleBLLFactory.createBGCScheduleBLL();
int ret = objbgcschedulebll.createBGCSchedule(objbgcschedulebo);
//MessageBox.Show("BGC Administrator Selected");
}
catch
{
throw;
}
}
public int createBGCSchedule(IBGCScheduleBO 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_bgcSchedule";
cmd.Parameters.AddWithValue("@fromDate", obj.From_Date);
cmd.Parameters.AddWithValue("@toDate", obj.To_Date);
cmd.Parameters.AddWithValue("@location", obj.Location);
cmd.Parameters.AddWithValue("@AdministratorID", obj.Administrator_Id);
cmd.Parameters.AddWithValue("@BGC_test_ID", 0);
cmd.Parameters["@BGC_test_ID"].Direction = ParameterDirection.Output;
cmd.ExecuteNonQuery();
con.Close();
return(ret);
}
public int updateBGCSchedule(IBGCScheduleBO obj)
{
int ret = 0;
return(ret);
}
