public int DL_CLogin(BLINSERT obj)
{
cmd.Connection = Opencon();
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@email", obj.Email);
cmd.Parameters.AddWithValue("@pwd", obj.Password);
cmd.CommandText = "COMPANY_LOGIN";
SqlDataAdapter dr = new SqlDataAdapter(cmd);
DataTable dt = new DataTable();
dr.Fill(dt);
Closecon();
if (dt.Rows.Count == 1)
{
obj.Sess_Rid = dt.Rows[0][1].ToString();
obj.Sess_User = dt.Rows[0][0].ToString();
return 1;
}
else
{
return 0;
}
}
public int DL_CReg(BLINSERT obj)
{
cmd.Connection = Opencon();
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@cname", obj.Cname);
cmd.Parameters.AddWithValue("@type", obj.Type);
cmd.Parameters.AddWithValue("@indus", obj.Industry);
cmd.Parameters.AddWithValue("@desc", obj.Description);
cmd.Parameters.AddWithValue("@addrs", obj.Address);
cmd.Parameters.AddWithValue("@phn", obj.Phone);
cmd.Parameters.AddWithValue("@email", obj.Email);
cmd.Parameters.AddWithValue("@pwd", obj.Password);
cmd.CommandText = "PROC_REG_COMPANY";
SqlParameter param = new SqlParameter();
param.ParameterName = "@rid";
cmd.Parameters.Add("@rid", DbType.Int32);
cmd.Parameters["@rid"].Direction = ParameterDirection.Output;
cmd.ExecuteNonQuery();
int r = Convert.ToInt32(cmd.Parameters["@rid"].Value);
Closecon();
cmd1.Connection = Opencon();
cmd1.CommandType = CommandType.StoredProcedure;
cmd1.Parameters.AddWithValue("@rid", r);
cmd1.Parameters.AddWithValue("@email", obj.Email);
cmd1.Parameters.AddWithValue("@pwd", obj.Password);
cmd1.CommandText = "PROC_LOGIN_COMPANY";
int i = cmd1.ExecuteNonQuery();
Closecon();
return i;
}
public int BL_UReg(BLINSERT obj)
{
int i = dl.DL_UReg(this);
return i;
}
//login
public int BL_ULogin(BLINSERT obj)
{
int i = dl.DL_ULogin(this);
return i;
}
public void BL_Show_DataList(BLINSERT obj)
{
dl.DL_Show_DataList(this);
}
public int BL_Post_Job(BLINSERT obj)
{
int i = dl.DL_Post_Job(this);
return i;
}
public int DL_UReg(BLINSERT obj)
{
cmd.Connection = Opencon();
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@fname", obj.Fname);
cmd.Parameters.AddWithValue("@lname", obj.Lname);
cmd.Parameters.AddWithValue("@loc", obj.Location);
cmd.Parameters.AddWithValue("@qual", obj.Qualification);
cmd.Parameters.AddWithValue("@indus", obj.Industry);
cmd.Parameters.AddWithValue("@skill", obj.Skills);
cmd.Parameters.AddWithValue("@exp", obj.Experience);
cmd.Parameters.AddWithValue("@phn", obj.Phone);
cmd.Parameters.AddWithValue("@email", obj.Email);
cmd.Parameters.AddWithValue("@pwd", obj.Password);
cmd.CommandText = "PROC_REG_USER";
SqlParameter param = new SqlParameter();
param.ParameterName = "@rid";
cmd.Parameters.Add("@rid", DbType.Int32);
cmd.Parameters["@rid"].Direction = ParameterDirection.Output;
cmd.ExecuteNonQuery();
int r = Convert.ToInt32(cmd.Parameters["@rid"].Value);
Closecon();
cmd1.Connection = Opencon();
cmd1.CommandType = CommandType.StoredProcedure;
cmd1.Parameters.AddWithValue("@rid", r);
cmd1.Parameters.AddWithValue("@email", obj.Email);
cmd1.Parameters.AddWithValue("@pwd", obj.Password);
cmd1.CommandText = "PROC_LOGIN_USER";
int i = cmd1.ExecuteNonQuery();
Closecon();
return i;
}
public void DL_Show_DataList(BLINSERT obj)
{
cmd.Connection = Opencon();
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "PROC_JOB_OPENING";
SqlDataAdapter dr = new SqlDataAdapter(cmd);
DataTable dt = new DataTable();
dr.Fill(dt);
Closecon();
obj.DL_Id.DataSource = dt;
obj.DL_Id.DataBind();
}
public int DL_Post_Job(BLINSERT obj)
{
cmd.Connection = Opencon();
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@title", obj.Title);
cmd.Parameters.AddWithValue("@type", obj.Type);
cmd.Parameters.AddWithValue("@loc", obj.Location);
cmd.Parameters.AddWithValue("@desc", obj.Description);
cmd.Parameters.AddWithValue("@qual", obj.Qualification);
cmd.Parameters.AddWithValue("@hrs", obj.Work_Hours);
cmd.Parameters.AddWithValue("@sal", obj.Salary);
cmd.Parameters.AddWithValue("@date", obj.Close_Date);
cmd.Parameters.AddWithValue("@company", obj.Cname);
cmd.CommandText = "PROC_POST_JOB";
int i = cmd.ExecuteNonQuery();
Closecon();
return i;
}