public string Create([Bind(Exclude = "ProjectID")] FinaceTool.Models.ProjectTemp projecttemp)
{
string msg;
if (projecttemp.OpportunityName != 0 && projecttemp.SOWStatus != 0)
{
Project project = new Project();
project.Createddate = System.DateTime.Now;
project.IsActive = true;
project.SowStatusID = projecttemp.SOWStatus;
project.OpportunityID = projecttemp.OpportunityName;
project.Createdby = Session["UserName"].ToString();
project.Modifiedby = Session["UserName"].ToString();
project.ProjectName = projecttemp.ProjectName;
project.poavilable = projecttemp.poavilable;
project.pobalance = projecttemp.pobalance;
project.Note = projecttemp.Note;
project.ProjectCode = projecttemp.ProjectCode;
db.Projects.Add(project);
db.SaveChanges();
int i = db.Usp_Update_Opportunity_IsMapped(projecttemp.OpportunityName);
// GetOpportunityNames();
msg = "Saved Successfully";
}
else
{
msg = "Opportunity Name Should provide to create a Project";
}
return(msg);
}
public string Edit(FinaceTool.Models.ProjectTemp projecttemp)
{
var result = db.Projects.SingleOrDefault(b => b.ProjectID == projecttemp.ProjectID);
string msg;
if (ModelState.IsValid && result != null)
{
result.Note = projecttemp.Note;
result.OpportunityID = projecttemp.OpportunityName;
result.poavilable = projecttemp.poavilable;
result.pobalance = projecttemp.pobalance;
result.ProjectName = projecttemp.ProjectName;
result.SowStatusID = projecttemp.SOWStatus;
result.Createdby = Session["UserName"].ToString();
result.Createddate = System.DateTime.Now;
result.ModifiedDate = System.DateTime.Now;
result.Modifiedby = Session["UserName"].ToString();
db.SaveChanges();
}
msg = "Saved Successfully";
return(msg);
}