public int AddExperience(int CompanyID, int DesignationID, string Year, bool InCamp, int JobTypeID, int IsSelected, int CTC, int NoOfRound, int OverallExperienceRate, string Summary, int UserID)
{
var DC = new DataClassesDataContext();
tblExperience experience = new tblExperience();
experience.CompanyID = CompanyID;
experience.DesignationID = DesignationID;
experience.Year = Year;
experience.InCamp = InCamp;
experience.JobTypeID = JobTypeID;
if (IsSelected == 1)
{
experience.IsSelected = true;
}
else
{
experience.IsSelected = false;
}
experience.CTC = CTC;
//experience.CityID = CityID;
experience.NoOfRound = NoOfRound;
experience.OverallExperienceRate = OverallExperienceRate;
experience.Summary = Summary;
experience.IsActive = true;
experience.CreatedBy = UserID;
experience.CreatedOn = DateTime.Now;
DC.tblExperiences.InsertOnSubmit(experience);
DC.SubmitChanges();
int ID = (from obj in DC.tblExperiences
orderby obj.ExeperienecesID descending
select obj.ExeperienecesID).FirstOrDefault();
return(ID);
}
public IList <string> GetExperienceDetail(int ExeperienecesID)
{
var DC = new DataClassesDataContext();
tblExperience Data = (from obj in DC.tblExperiences
where obj.ExeperienecesID == ExeperienecesID
select obj).SingleOrDefault();
IList <string> list = new string[] { Data.CreatedBy.ToString(), Data.CompanyID.ToString(), Data.DesignationID.ToString(), Data.Year, Data.JobTypeID.ToString(), Data.IsSelected.ToString(), Data.CTC.ToString(), Data.InCamp.ToString() };
return(list);
}
public ActionResult Guncelle(tblExperience d)
{
var dgr = db.tblExperience.Find(d.Id);
dgr.Title = d.Title;
dgr.SubTitle = d.SubTitle;
dgr.Date = d.Date;
dgr.Details = d.Details;
db.SaveChanges();
return(RedirectToAction("Index", "Deneyimlerim"));
}
public ActionResult YeniDeneyim(tblExperience d)
{
db.tblExperience.Add(d);
db.SaveChanges();
return(RedirectToAction("Index", "Deneyimlerim"));
}
