public static bool SaveExperienceDetail(tbl_Experiences _Experience)
{
bool _result = true;
using (PortfolioDBEntities db = new PortfolioDBEntities())
{
try
{
if (_Experience.Experience_id == 0)
{
_Experience.User_id = 1;
db.tbl_Experiences.Add(_Experience);
}
else
{
db.tbl_Experiences.Attach(_Experience);
db.Entry(_Experience).State = System.Data.Entity.EntityState.Modified;
}
db.SaveChanges();
}
catch (Exception)
{
_result = true;
}
}
return(_result);
}
public ActionResult Experience(tbl_Experiences _Experience, FormCollection formexperience)
{
_Experience.Company = formexperience["input_company_name"];
_Experience.Duration = formexperience["input_duration_name"];
_Experience.ExperienceDetail = formexperience["input_experienceDetail_name"];
_Experience.Title = formexperience["input_title_name"];
Data.Data.SaveExperienceDetail(_Experience);
return(View());
}
public ActionResult Experience(int?id)
{
if (id != null)
{
tbl_Experiences _Experiences = Data.Data.get_experience(id);
ViewBag.TitleBag = _Experiences.Title;
ViewBag.ExperienceDetailBag = _Experiences.ExperienceDetail;
ViewBag.CompanyBag = _Experiences.Company;
ViewBag.DurationBag = _Experiences.Duration;
}
return(View());
}
public ActionResult Create(ExperiencesModel expModel)
{
var dataSet = Session["Users"] as tbl_Member;
var experience = new tbl_Experiences();
experience.ExpID = expModel.ExpID;
experience.CompanyName = expModel.CompanyName;
experience.Position = expModel.Position;
experience.StartDate = expModel.StartDate;
experience.FinishDate = expModel.FinishDate;
experience.fk_UserID = dataSet.UserID;
db.tbl_Experiences.Add(experience);
db.SaveChanges();
return(RedirectToAction("Show", "Experiences"));
}
