public CommonModal Insert(AdJobModel a)
{
CommonModal e1 = new CommonModal();
SqlConnection conn = new SqlConnection(commonCode.conStr);
conn.Open();
SqlCommand cmd = new SqlCommand("Pro_Adjobmaster", conn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@login_Id", SqlDbType.Int).Value = a.login_Id;
cmd.Parameters.Add("@category_Id", SqlDbType.Int).Value = a.category_Id;
cmd.Parameters.Add("@subCategory_Id ", SqlDbType.Int).Value = a.subCategory_Id;
cmd.Parameters.Add("@Job_Title", SqlDbType.NVarChar).Value = a.Job_Title;
cmd.Parameters.Add("@JobType", SqlDbType.NVarChar).Value = a.JobType;
cmd.Parameters.Add("@Description", SqlDbType.NVarChar).Value = a.Description;
cmd.Parameters.Add("@Salary_From", SqlDbType.Int).Value = a.Salary_From;
cmd.Parameters.Add("@Salary_To", SqlDbType.Int).Value = a.Salary_To;
cmd.Parameters.Add("@Contact_Person", SqlDbType.NVarChar).Value = a.Contact_Person;
cmd.Parameters.Add("@Mobile_No", SqlDbType.NVarChar).Value = a.Mobile_No;
cmd.Parameters.Add("@Landline_No", SqlDbType.NVarChar).Value = a.Landline_No;
cmd.Parameters.Add("@Experience", SqlDbType.NVarChar).Value = a.Experience;
cmd.Parameters.Add("@Location", SqlDbType.NVarChar).Value = a.Location;
cmd.Parameters.Add("@location_id", SqlDbType.NVarChar).Value = a.location_id;
cmd.Parameters.Add("@payment_status ", SqlDbType.Int).Value = a.payment_status;
cmd.Parameters.Add("@Addressofcompany", SqlDbType.NVarChar).Value = a.Addressofcompany;
cmd.Parameters.Add("@image1", SqlDbType.NVarChar).Value = a.image1;
cmd.Parameters.Add("@mode", SqlDbType.NVarChar).Value = a.mode;
DataSet ds = new DataSet();
SqlDataAdapter da = new SqlDataAdapter();
da.SelectCommand = cmd;
da.Fill(ds);
DataTable Dt = ds.Tables[0];
DataTable Dt1 = ds.Tables[1];
conn.Close();
if (Dt.Rows.Count > 0)
{
e1.ResponseStatus = Dt1.Rows[0]["status"].ToString();
e1.ResponseMessage = Dt1.Rows[0]["MSG"].ToString();
e1.data = Dt;
}
else
{
e1.ResponseStatus = "False";
e1.ResponseMessage = "Job Apply Failed";
}
return(e1);
}
public DataTable getjob(AdJobModel a)
{
SqlConnection conn = new SqlConnection(commonCode.conStr);
conn.Open();
SqlCommand cmd = new SqlCommand("Pro_Adjobmaster", conn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@Job_Id", SqlDbType.Int).Value = a.Job_Id;
cmd.Parameters.Add("@login_Id", SqlDbType.Int).Value = a.login_Id;
cmd.Parameters.Add("@category_Id", SqlDbType.Int).Value = a.category_Id;
cmd.Parameters.Add("@subCategory_Id", SqlDbType.Int).Value = a.subCategory_Id;
cmd.Parameters.Add("@lastDate", SqlDbType.DateTime).Value = a.lastDate == Convert.ToDateTime("1/1/0001 12:00:00 AM") ? DateTime.Now : a.lastDate;
cmd.Parameters.Add("@dataCount", SqlDbType.Int).Value = a.dataCount;
cmd.Parameters.Add("@location_id", SqlDbType.NVarChar).Value = a.location_id;
cmd.Parameters.Add("@mode", SqlDbType.NVarChar).Value = a.mode;
DataSet ds = new DataSet();
SqlDataAdapter da = new SqlDataAdapter();
da.SelectCommand = cmd;
da.Fill(ds);
DataTable Dt = ds.Tables[0];
conn.Close();
if (Dt.Rows.Count > 0)
{
List <AdJobModel> fm = new List <AdJobModel>();
fm = commonCode.ConvertDataTable <AdJobModel>(Dt);
for (int i = 0; i < fm.Count; i++)
{
fm[i].favlogins = listfav(fm[i].Job_Id);
}
Dt = ToDataTable(fm);
}
return(Dt);
}
public int delete(AdJobModel a)
{
try
{
SqlConnection con = new SqlConnection(commonCode.conStr);
con.Open();
SqlCommand cmd = new SqlCommand("Pro_Adjobmaster", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@Job_Id", SqlDbType.Int).Value = a.Job_Id;
cmd.Parameters.Add("@mode", SqlDbType.NVarChar).Value = a.mode;
int s = (int)cmd.ExecuteNonQuery();
con.Close();
if (s < 0)
{
s = -1;
}
return(s);
}
catch (Exception ex)
{
return(-1);
}
}
