public ActionResult Create(tblProject tblProject) { tblProjectDap newDap = new tblProjectDap(); if (tblProject.fldProjectID == 0) { if (newDap.AddProject(tblProject, 0)) { return RedirectToAction("Index"); } else { return View(); } } else { if (newDap.AddProject(tblProject, tblProject.fldProjectID)) { return RedirectToAction("Index"); } else { return View(); } } }
private void ctxUpdate_Click(object sender, EventArgs e) { tblProject curProject = new tblProject(); tblProjectDap newDap = new tblProjectDap(); curProject = newDap.GetByfldProjectTreeID(curSelectedNode.Key); frmErga_Single newSingle = new frmErga_Single(curProject.fldProjectID,0, enums.formState.Update); newSingle.ShowDialog(); FillTree(); }
private void ctxAdd_SubTask_Click(object sender, EventArgs e) { tblProject parentProject = new tblProject(); tblProjectDap newDap = new tblProjectDap(); parentProject = newDap.GetByfldProjectTreeID(curSelectedNode.Key); frmErga_Single newSingle = new frmErga_Single(0,parentProject.fldProjectID, enums.formState.AddChild); newSingle.ShowDialog(); FillTree(); }
// GET: /Projects/Create public ActionResult CreatePartial(long id) { if (id == 0) { tblProject childProject = new tblProject(); childProject.fldProjectID = 0; return PartialView("_PartialCreateProject", childProject); } else { tblProject parentProject = new tblProject(); tblProject childProject = new tblProject(); tblProjectDap newDap = new tblProjectDap(); parentProject = newDap.GetByfldProjectID(id); childProject.fldProjectID = parentProject.fldProjectID; childProject.fldProjectTreeID = parentProject.fldProjectTreeID; return PartialView("_PartialCreateProject",childProject); } }
private void cmdAdd_Click(object sender, EventArgs e) { _tblProject = new tblProject(); saveFormToObject(_tblProject); tblProjectDap newDap = new tblProjectDap(); switch (fState) { case enums.formState.Add: newDap.AddProject(_tblProject, 0); //SaveGrids(); break; case enums.formState.AddChild: _tblProject.fldParentID = _fldParentProjectID; newDap.AddProject(_tblProject, _fldParentProjectID); //SaveGrids(); break; } MessageBox.Show("Η εισαγωγή ολοκληρώθηκε", "Μήνυμα"); fState = enums.formState.Update; updateButtons(fState); }
public bool AddProject(tblProject model, long parentProjectID) { try { tblProjectDap newDap = new tblProjectDap(); if (parentProjectID == 0) { string strMaxnum = (newDap.Query<string>( "select max(fldProjectTreeID) from tblProject where len(fldProjectTreeID) =5 ")) .FirstOrDefault().ToString(); long lngMaxnum = long.Parse(strMaxnum); lngMaxnum += 1; strMaxnum = ("0000" + lngMaxnum.ToString()).ToString(); strMaxnum = strMaxnum.Substring(strMaxnum.Length - 5); model.fldProjectTreeID = strMaxnum; model.fldProjectTreeCode = lngMaxnum.ToString(); } else { tblProject parentProject = new tblProject(); parentProject = GetByfldProjectID(parentProjectID); int fldProjectTreeIDLen = parentProject.fldProjectTreeID.Length; //string qry = "select max(fldProjectTreeID) from tblProject where len(fldProjectTreeID) = " + // (fldProjectTreeIDLen + 5).ToString() + " and tblProject.fldProjectTreeID like '" + // parentProjectID + "%' "; string qry = "select max(fldProjectTreeID) from tblProject where len(fldProjectTreeID) = " + (fldProjectTreeIDLen + 5).ToString() + " and tblProject.fldProjectTreeID like @parentProjectID "; //var res = (newDap.Query<string>(qry)).FirstOrDefault(); var res = (newDap.Query<string>(qry, new { parentProjectID = parentProject.fldProjectTreeID + "%" })).FirstOrDefault(); if (res != null) { long lngMaxnum = long.Parse(res.ToString().Right(5)); lngMaxnum += 1; string strMaxnum = ("0000" + lngMaxnum.ToString()).ToString(); strMaxnum = strMaxnum.Right(5); model.fldProjectTreeID = res.ToString().Left(res.ToString().Length - 5) + strMaxnum; model.fldParentID = parentProject.fldProjectID; model.fldProjectTreeCode = StringExtensions.ConvertHierachicaltoCode(model.fldProjectTreeID, 5); } else { model.fldProjectTreeID = parentProject.fldProjectTreeID + "00001"; model.fldParentID = parentProject.fldProjectID; model.fldProjectTreeCode = StringExtensions.ConvertHierachicaltoCode(model.fldProjectTreeID, 5); } } newDap.Insert(model); return true; } catch { return false; } }
private void saveFormToObject(tblProject tblProject) { Assign.GenericAssign(this.fldProjectName.Text, value => tblProject.fldProjectName = value); Assign.GenericAssign(this.fldProjectDescription.Text, value => tblProject.fldProjectDescription = value); Assign.GenericAssign((DateTime?)this.fldDateStart.Value, value => tblProject.fldDateStart = value); Assign.GenericAssign((DateTime?)this.fldDateCompletePlanned.Value, value => tblProject.fldDateCompletePlanned = value); Assign.GenericAssign((DateTime?)this.fldDateCompleteActual.Value, value => tblProject.fldDateCompleteActual = value); Assign.GenericAssign(this.fldIsCompleted.Checked, value => tblProject.fldIsCompleted = value); }
private void loadFormfromObject(tblProject tblProject) { Assign.GenericAssign(_tblProject.fldProjectID.ToString(), value => this.fldProjectID.Text = value); Assign.GenericAssign(_tblProject.fldProjectName, value => this.fldProjectName.Text = value); Assign.GenericAssign(_tblProject.fldProjectDescription, value => this.fldProjectDescription.Text = value); Assign.GenericAssign(_tblProject.fldDateStart, value => this.fldDateStart.Value = value); Assign.GenericAssign(_tblProject.fldDateCompletePlanned, value => this.fldDateCompletePlanned.Value = value); Assign.GenericAssign(_tblProject.fldDateCompleteActual, value => this.fldDateCompleteActual.Value = value); Assign.GenericAssign(_tblProject.fldIsCompleted, value => this.fldIsCompleted.Checked = value); }
private void frmErga_Single_Load(object sender, EventArgs e) { updateButtons(fState); FillCombos(); switch (fState) { case enums.formState.Add: break; case enums.formState.AddChild: break; case enums.formState.Update: case enums.formState.Delete: { tblProjectDap newDap = new tblProjectDap(); _tblProject = newDap.GetByfldProjectID(_fldProjectID); loadFormfromObject(_tblProject); FillGrids(); } break; } }
public void Update(tblProject model) { Execute(SqlUpdateCommand, model); }
public void Insert(tblProject model) { Execute(SqlInsertCommand, model); }
public ActionResult CreatePartial(tblProject tblProject) { try { tblProjectDap newDap = new tblProjectDap(); if (tblProject.fldProjectID == 0) { string strMaxnum = (newDap.Query<string>( "select max(fldProjectTreeID) from tblProject where len(fldProjectTreeID) =5 ")) .FirstOrDefault().ToString(); long lngMaxnum = long.Parse(strMaxnum); lngMaxnum += 1; strMaxnum = ("0000" + lngMaxnum.ToString()).ToString(); strMaxnum = strMaxnum.Substring(strMaxnum.Length - 5); tblProject.fldProjectTreeID = strMaxnum; tblProject.fldProjectTreeCode = lngMaxnum.ToString(); } else { int fldProjectTreeIDLen = tblProject.fldProjectTreeID.Length; string qry = "select max(fldProjectTreeID) from tblProject where len(fldProjectTreeID) = " + (fldProjectTreeIDLen + 5).ToString() + " and tblProject.fldProjectTreeID like '" + tblProject.fldProjectTreeID + "%' "; var res = (newDap.Query<string>(qry)).FirstOrDefault(); if (res != null) { long lngMaxnum = long.Parse(res.ToString().Right(5)); lngMaxnum += 1; string strMaxnum = ("0000" + lngMaxnum.ToString()).ToString(); strMaxnum = strMaxnum.Right(5); tblProject.fldProjectTreeID = res.ToString().Left(res.ToString().Length-5) + strMaxnum; tblProject.fldParentID = tblProject.fldProjectID; tblProject.fldProjectTreeCode = StringExtensions.ConvertHierachicaltoCode(tblProject.fldProjectTreeID,5); } else { tblProject.fldProjectTreeID = tblProject.fldProjectTreeID + "00001"; tblProject.fldParentID = tblProject.fldProjectID; tblProject.fldProjectTreeCode = StringExtensions.ConvertHierachicaltoCode(tblProject.fldProjectTreeID, 5); } } newDap.Insert(tblProject); return RedirectToAction("Index"); } catch { return View(); } }
public ActionResult Edit(tblProject tlProject) { try { if (ModelState.IsValid) { tblProjectDap newDap = new tblProjectDap(); newDap.Update(tlProject); return RedirectToAction("Index"); } else { return RedirectToAction("Index"); } } catch { return View(); } }
// // GET: /Projects/Edit/5 public ActionResult Edit(int id) { tblProject editProject = new tblProject(); tblProjectDap newDap = new tblProjectDap(); editProject = newDap.GetByfldProjectID(id); return View(editProject); // return PartialView("_PartialEditProject", editProject); }
// // GET: /Projects/Details/5 public ActionResult Details(int id) { tblProject editProject = new tblProject(); tblProjectDap newDap = new tblProjectDap(); editProject = newDap.GetByfldProjectID(id); return View(editProject); }