public void UpdateProjectFollowUp(ProjectFollowUp followUp)
{
using (SqlConnection connection = SqlHelper.GetOpenConnection())
{
connection.Update(followUp);
}
}
public int CreateProjectFollowUp(ProjectFollowUp followUp)
{
using (SqlConnection connection = SqlHelper.GetOpenConnection())
{
int projectId = connection.Insert(followUp);
return(projectId);
}
}
public void UpdateProjectGoal(FollowUpModel followUpModel)
{
// Mapp to backend model
var followUp = new ProjectFollowUp();
if (followUpModel != null)
{
followUp = ApplicationMapper.MapProjectFollowUp(followUpModel);
}
// Create P.FollowUp
projectRepository.UpdateProjectFollowUp(followUp);
}
public int CreateProjectFollowUp(FollowUpModel followUpModel)
{
// Mapp to backend model
var followUp = new ProjectFollowUp();
if (followUpModel != null)
{
followUp = ApplicationMapper.MapProjectFollowUp(followUpModel);
}
// Create P.followup
return(projectRepository.CreateProjectFollowUp(followUp));
}
public static ProjectFollowUp MapProjectFollowUp(FollowUpModel followUpModel)
{
var followup = new ProjectFollowUp
{
ProjectId = followUpModel.ProjectId,
Id = followUpModel.Id,
Date = followUpModel.Date.GetMyLocalTime(),
InternalHours = followUpModel.InternalHours,
ExternalHours = followUpModel.ExternalHours,
OtherCosts = followUpModel.OtherCosts,
ActivityTotal = followUpModel.ActivityTotal,
Notes = followUpModel.Notes,
Canceled = followUpModel.Canceled
};
return(followup);
}
public IActionResult AddProjection(IFormCollection formCollection)
{
List <FollowInfo> list = new List <FollowInfo>();
Project p = projectmanager.getProjet(Convert.ToInt32(formCollection["id"]));
string[] Spending = formCollection["Spending"];
string[] montant = formCollection["Montant"];
string[] color = formCollection["color"];
int count = 0;
foreach (var item in p.listProjectSoumission())
{
FollowInfo f = new FollowInfo();
f.amount = Convert.ToDouble(montant[count]);
f.Spending = Spending[count];
f.color = color[count];
list.Add(f);
count++;
}
ProjectFollowUp projectFollowUp = new ProjectFollowUp();
projectFollowUp.PfFollowUpId = Convert.ToInt32(formCollection["id"]);
FollowUp follow = new FollowUp();
follow.FuDate = DateTime.Now;
follow.FuInfo = JsonConvert.SerializeObject(list);
FollowUp ff = new FollowUp();
ff = _context.FollowUp.Last();
_context.Add(follow);
_context.SaveChanges();
projectFollowUp.PfFollowUpId = follow.FuId;
projectFollowUp.PfProject = p;
projectFollowUp.PfFollowUp = follow;
_context.ProjectFollowUp.Add(projectFollowUp);
_context.SaveChanges();
return(RedirectToAction("Projet", new { id = formCollection["id"] }));
}
private void listViewProjectFollowUp_DoubleClick(object sender, EventArgs e)
{
FollowUp followUp = (FollowUp)listViewProjectFollowUp.SelectedItems[0].Tag;
ProjectFollowUp projectFollowUp = new ProjectFollowUp(followUp);
projectFollowUp.ShowDialog();
DisplayFollowUps(_followUpList);
}
private void buttonProjectAddFollowUp_Click(object sender, EventArgs e)
{
ProjectFollowUp projectFollowUp = new ProjectFollowUp();
projectFollowUp.ShowDialog();
if (projectFollowUp.FollowUp != null)
{
FollowUp followUp = projectFollowUp.FollowUp;
_followUpList.Add(followUp);
DisplayFollowUps(_followUpList);
}
}
public IActionResult Addprojet(IFormCollection formCollection)
{
ProjectFollowUp projectFollowUp = new ProjectFollowUp();
ProjectExpense projectExpense = new ProjectExpense();
Project p = new Project();
p.ProjectName = formCollection["ProjectName"];
p.ProjectDebut = Convert.ToDateTime(formCollection["project_debut"]);
p.ProjectFin = Convert.ToDateTime(formCollection["project-fin"]);
//TOFIX: La sérialisation JSON Échoue s'il y a plus qu'un mot dans le champ "Spending"
//I know on va juste empecher avec des espaces
FollowInfo[] follwlist = new JavaScriptSerializer().Deserialize <FollowInfo[]>(formCollection["table"]);
List <FollowInfo> soumission = new List <FollowInfo>();
foreach (var item in follwlist)
{
soumission.Add(item);
}
FollowUp follow = new FollowUp();
follow.FuDate = DateTime.Now;
follow.FuInfo = JsonConvert.SerializeObject(soumission);
List <ExpenseInfo> expenseInfo = new List <ExpenseInfo>();
foreach (var item in soumission)
{
ExpenseInfo expenses = new ExpenseInfo();
List <FollowInfo> subex = new List <FollowInfo>();
FollowInfo ex = new FollowInfo();
expenses.Spending = item.Spending;
expenses.amount = 0;
ex.Spending = "Title";
ex.amount = 0;
subex.Add(ex);
expenses.subExpenses = subex;
expenseInfo.Add(expenses);
}
Expense expense = new Expense();
expense.ExpenseDate = DateTime.Now;
expense.JsonExpenseInfo = JsonConvert.SerializeObject(expenseInfo);
_context.Add(follow);
_context.Add(expense);
_context.SaveChanges();
projectFollowUp.PfFollowUpId = follow.FuId;
projectFollowUp.PfProject = p;
projectExpense.PeExpenseId = expense.ExpenseId;
projectExpense.PeProject = p;
p.ProjectSoumission = JsonConvert.SerializeObject(soumission);
Users user = new Users();
user = usermanager.FindUserByID(formCollection["Users"]);
projectmanager.addProjet(p);
projectFollowUp.PfFollowUp = follow;
projectExpense.PeExpense = expense;
_context.ProjectFollowUp.Add(projectFollowUp);
_context.ProjectExpense.Add(projectExpense);
_context.SaveChanges();
return(RedirectToAction("Index"));
}
