public AddExperienceModel GetExperience_Byid(int id)
{
string spName = "[GetExperience_by_id]";
List <SqlParameter> sqlParameters = new List <SqlParameter>();
sqlParameters.Add(DBClient.AddParameters("id", SqlDbType.Int, id));
AddExperienceModel jobData = CommonDal.SelectObject <AddExperienceModel>(spName, sqlParameters.ToArray());
return(jobData);
}
public void AddExperienceM(AddExperienceModel ObjExperience, int id)
{
string spName = "[AddExperience]";
List <SqlParameter> sqlParameters = new List <SqlParameter>();
sqlParameters.Add(DBClient.AddParameters("u_id", SqlDbType.Int, id));
sqlParameters.Add(DBClient.AddParameters("job_title", SqlDbType.VarChar, ObjExperience.job_title));
sqlParameters.Add(DBClient.AddParameters("company", SqlDbType.VarChar, ObjExperience.company));
sqlParameters.Add(DBClient.AddParameters("starting_month", SqlDbType.VarChar, ObjExperience.starting_month));
sqlParameters.Add(DBClient.AddParameters("starting_year", SqlDbType.VarChar, ObjExperience.starting_year));
sqlParameters.Add(DBClient.AddParameters("ending_month", SqlDbType.VarChar, ObjExperience.ending_month));
sqlParameters.Add(DBClient.AddParameters("ending_year", SqlDbType.VarChar, ObjExperience.ending_year));
sqlParameters.Add(DBClient.AddParameters("description ", SqlDbType.VarChar, ObjExperience.description));
sqlParameters.Add(DBClient.AddParameters("currently_working_here", SqlDbType.Bit, ObjExperience.currently_working_here));
CommonDal.Crud(spName, sqlParameters.ToArray());
}
public JsonResult GetExperience_By_id(int id)
{
UserBal bl = new UserBal();
AddExperienceModel addExperienceModel = new AddExperienceModel();
addExperienceModel = bl.GetExperience_Byid(id);
if (addExperienceModel.job_title != null)
{
TempData["Message"] = "Update Successfully";
return(Json(addExperienceModel, JsonRequestBehavior.AllowGet));
}
else
{
return(Json(addExperienceModel));
}
}
