public string AddProject(projectDetails projDetails, int?sno)
{
projectEstimatorEntities e = new projectEstimatorEntities();
string message = "Project Details are saved successfully..!";
if (sno != null)
{
projectDetail p = new projectDetail();
p = (from pd in e.projectDetails where pd.sno == sno select pd).SingleOrDefault();
p.projectName = projDetails.ProjectName;
p.devActivityHours = JsonConvert.SerializeObject(projDetails);
p.Employee = "";
e.SaveChanges();
message = "Project Details are updated successfully..!";
}
else
{
projectDetail p = new projectDetail();
p.projectName = projDetails.ProjectName;
p.devActivityHours = JsonConvert.SerializeObject(projDetails);
p.Employee = "";
e.projectDetails.Add(p);
e.SaveChanges();
}
return(message); // View(message, JsonRequestBehavior.AllowGet);
}
public JsonResult AddNewUser(user ud)
{
string message = "";
try
{
projectEstimatorEntities pe = new projectEstimatorEntities();
user u = new user();
int checkUser = (from us in pe.users where us.userName == ud.userName select us).Count();
if (checkUser == 0)
{
u.userName = ud.userName;
u.password = ud.password;
pe.users.Add(u);
pe.SaveChanges();
message = "User Added Successfully..!";
}
else
{
message = "User Already Exist..!";
}
}
catch (Exception ex)
{
message = ex.Message.ToString();
}
return(Json(message, JsonRequestBehavior.AllowGet));
}
public ActionResult DeleteProject(int projectID)
{
projectDetail p = new projectDetail();
projectEstimatorEntities pe = new projectEstimatorEntities();
p = (from pp in pe.projectDetails where pp.sno.Equals(projectID) select pp).FirstOrDefault();
pe.projectDetails.Remove(p);
pe.SaveChanges();
return(Json("Project Deleted Successfully..!", JsonRequestBehavior.AllowGet));
}
