public DataSet UpdatePersonalUser(PesrsonalUser _ur)
{
DataSet dt = new DataSet();
try
{
SqlConnection con = new SqlConnection(conStr);
SqlCommand cmd = new SqlCommand("sp_update_UserType_PersonalDeatils", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@Rec_ID", _ur.Rec_ID);
cmd.Parameters.AddWithValue("@UserID", _ur.UserID);
cmd.Parameters.AddWithValue("@FirstName", _ur.FirstName);
cmd.Parameters.AddWithValue("@LastName", _ur.LastName);
cmd.Parameters.AddWithValue("@Mobile", _ur.Mobile);
cmd.Parameters.AddWithValue("@Email", _ur.Email);
cmd.Parameters.AddWithValue("@Country", _ur.Country);
cmd.Parameters.AddWithValue("@State", _ur.State);
cmd.Parameters.AddWithValue("@City", _ur.City);
cmd.Parameters.AddWithValue("@zipcode", _ur.zipcode);
cmd.Parameters.AddWithValue("@Designation", _ur.Designation);
cmd.Parameters.AddWithValue("@YearsOfExp", _ur.YearsOfExp);
cmd.Parameters.AddWithValue("@Experience", _ur.Experience);
/////////////////////////////////
cmd.Parameters.AddWithValue("@PresentCompanyName", _ur.PresentCompanyName);
cmd.Parameters.AddWithValue("@PeriodOfWorking", _ur.PeriodOfWorking);
cmd.Parameters.AddWithValue("@Work_Sector", _ur.Work_Sector);
cmd.Parameters.AddWithValue("@Last_Salary", _ur.Last_Salary);
cmd.Parameters.AddWithValue("@Altenative_mobile", _ur.Altenative_mobile);
cmd.Parameters.AddWithValue("@AboutMe", _ur.AboutMe);
cmd.Parameters.AddWithValue("@Resume", _ur.Resume);
cmd.Parameters.AddWithValue("@UserType", _ur.UserType);
cmd.Parameters.AddWithValue("@CurrencyType", _ur.CurrencyType);
cmd.Parameters.AddWithValue("@ImgPath", _ur.ImgPath);
con.Open();
SqlDataAdapter da = new SqlDataAdapter(cmd);
da.Fill(dt);
con.Close();
}
catch (Exception ex)
{
dt = null;
}
return(dt);
}
public DataSet GetUserDetailsByJobID(PesrsonalUser _ur)
{
DataSet dt = new DataSet();
try
{
SqlConnection con = new SqlConnection(conStr);
SqlCommand cmd = new SqlCommand("sp_get_UserDeatilsByJobID", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@JobID", _ur.Rec_ID);
con.Open();
SqlDataAdapter da = new SqlDataAdapter(cmd);
da.Fill(dt);
con.Close();
}
catch (Exception ex)
{
dt = null;
}
return(dt);
}
public Response GetUserDeatailsByJobID(PesrsonalUser model)
{
try
{
var response = new Response();
DataSet ds = null;
ds = blObj.GetUserDetailsByJobID(model);
if (ds != null && ds.Tables.Count > 0)
{
List <PesrsonalUser> userdetails = new List <PesrsonalUser>();
if (ds.Tables[0].Rows[0][0].ToString() == "200")
{
if (ds.Tables[1].Rows.Count > 0)
{
foreach (DataRow dr in ds.Tables[1].Rows)
{
PesrsonalUser data = new PesrsonalUser();
data.UserID = dr["UserID"].ToString();
data.FirstName = dr["FirstName"].ToString();
data.LastName = dr["LastName"].ToString();
data.Mobile = dr["Mobile"].ToString();
data.Email = dr["Email"].ToString();
data.UserType = dr["UserType"].ToString();
userdetails.Add(data);
}
response = new Response
{
ResponseCode = ds.Tables[0].Rows[0]["Statuscode"].ToString(),
ResponseMessage = ds.Tables[0].Rows[0]["Message"].ToString(),
ResponseList = new
{
userdetails
}
};
}
}
else
{
response = new Response
{
ResponseCode = ds.Tables[0].Rows[0]["Statuscode"].ToString(),
ResponseMessage = ds.Tables[0].Rows[0]["Message"].ToString(),
};
}
}
else
{
response = new Response
{
ResponseCode = Common.ReturnCode("ErrorCode"),
ResponseMessage = Common.ReturnCode("ErrorMessage")
};
}
return(response);
}
catch (Exception ex)
{
return(new Response
{
ResponseCode = Common.ReturnCode("ErrorCode"),
ResponseMessage = Common.ReturnCode("ErrorMessage")
});
}
}
public Response UpdateUserPersonalDeatails(PesrsonalUser model)
{
try
{
var response = new Response();
DataSet ds = null;
ds = blObj.UpdatePersonalUser(model);
if (ds != null && ds.Tables.Count > 0)
{
List <PesrsonalUser> userdetails = new List <PesrsonalUser>();
if (ds.Tables[0].Rows[0][0].ToString() == "200")
{
if (ds.Tables[1].Rows.Count > 0)
{
foreach (DataRow dr in ds.Tables[1].Rows)
{
PesrsonalUser data = new PesrsonalUser();
data.Rec_ID = dr["Rec_ID"].ToString();
data.UserID = dr["UserID"].ToString();
data.FirstName = dr["FirstName"].ToString();
data.LastName = dr["LastName"].ToString();
data.Mobile = dr["Mobile"].ToString();
data.Email = dr["Email"].ToString();
data.Country = dr["Country"].ToString();
data.State = dr["State"].ToString();
data.City = dr["City"].ToString();
data.zipcode = dr["zipcode"].ToString();
data.Designation = dr["Designation"].ToString();
data.YearsOfExp = dr["YearsOfExp"].ToString();
data.Experience = dr["Experience"].ToString();
data.PresentCompanyName = dr["PresentCompanyName"].ToString();
data.PeriodOfWorking = dr["PeriodOfWorking"].ToString();
data.Work_Sector = dr["Work_Sector"].ToString();
data.Last_Salary = dr["Last_Salary"].ToString();
data.Altenative_mobile = dr["Altenative_mobile"].ToString();
data.AboutMe = dr["AboutMe"].ToString();
data.Resume = dr["Resume"].ToString();
data.UserType = dr["UserType"].ToString();
data.CurrencyType = dr["CurrencyType"].ToString();
data.ImgPath = dr["ImgPath"].ToString();
userdetails.Add(data);
}
response = new Response
{
ResponseCode = ds.Tables[0].Rows[0]["Statuscode"].ToString(),
ResponseMessage = ds.Tables[0].Rows[0]["Message"].ToString(),
ResponseList = new
{
userdetails
}
};
}
}
else
{
response = new Response
{
ResponseCode = ds.Tables[0].Rows[0]["Statuscode"].ToString(),
ResponseMessage = ds.Tables[0].Rows[0]["Message"].ToString(),
};
}
}
else
{
response = new Response
{
ResponseCode = Common.ReturnCode("ErrorCode"),
ResponseMessage = Common.ReturnCode("ErrorMessage")
};
}
return(response);
}
catch (Exception ex)
{
return(new Response
{
ResponseCode = Common.ReturnCode("ErrorCode"),
ResponseMessage = Common.ReturnCode("ErrorMessage")
});
}
}
