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