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();
}
private void cmdUpdate_Click(object sender, EventArgs e)
{
saveFormToObject(_tblProject);
tblProjectDap newDap = new tblProjectDap();
SaveGrids();
newDap.Update(_tblProject);
MessageBox.Show("Η ενημέρωση ολοκληρώθηκε", "Μήνυμα");
}
// 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 FillTree()
{
Infragistics.Win.UltraWinTree.UltraTreeNode anode = null;
Infragistics.Win.UltraWinTree.UltraTreeNode bnode = null;
this.ultraTree1.ViewStyle = Infragistics.Win.UltraWinTree.ViewStyle.OutlookExpress;
// UltraTreeColumnSet commonColumnSet = ultraTree1.ColumnSettings.ColumnSets["ErgaColumnSet"];
//Data Retrieval
List<tblProject> listOfProjects = new List<tblProject>();
tblProjectDap newDap = new tblProjectDap();
listOfProjects = newDap.GetAllOrderByfldProjectTreeID();
ultraTree1.Nodes.Clear();
foreach (var Projectitem in listOfProjects)
{
int keyLength = 0;
string parentKey = "";
keyLength = Projectitem.fldProjectTreeID.Length;
if (keyLength == 5)
{
anode = ultraTree1.Nodes.Add(Projectitem.fldProjectTreeID, Projectitem.fldProjectName);
anode.Cells["fldProjectID"].Value = Projectitem.fldProjectID;
anode.Cells["fldProjectTreeCode"].Value = Projectitem.fldProjectTreeCode;
anode.Cells["fldProjectName"].Value = Projectitem.fldProjectName;
anode.Cells["fldDateStart"].Value = Projectitem.fldDateStart;
anode.Cells["fldIsCompleted"].Value = Projectitem.fldIsCompleted;
}
else
{
parentKey = Projectitem.fldProjectTreeID.Left(keyLength - 5);
anode = ultraTree1.GetNodeByKey(parentKey);
bnode = anode.Nodes.Add(Projectitem.fldProjectTreeID, Projectitem.fldProjectName);
bnode.Cells["fldProjectID"].Value = Projectitem.fldProjectID;
bnode.Cells["fldProjectTreeCode"].Value = Projectitem.fldProjectTreeCode;
bnode.Cells["fldProjectName"].Value = Projectitem.fldProjectName;
bnode.Cells["fldDateStart"].Value = Projectitem.fldDateStart;
bnode.Cells["fldIsCompleted"].Value = Projectitem.fldIsCompleted;
}
}
}
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);
}
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 tblProject GettblProjectByfldProjectID(Int64 fldProjectID)
{
using (var dap = new tblProjectDap(this))
{
return dap.GetByfldProjectID(fldProjectID);
}
}
//
// GET: /Projects/Details/5
public ActionResult Details(int id)
{
tblProject editProject = new tblProject();
tblProjectDap newDap = new tblProjectDap();
editProject = newDap.GetByfldProjectID(id);
return View(editProject);
}
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();
}
}
//
// GET: /Projects/
public ActionResult Index2()
{
List<tblProject> listOfProjects = new List<tblProject>();
tblProjectDap newDap = new tblProjectDap();
listOfProjects = newDap.GetAllOrderByfldProjectTreeID();
return View(listOfProjects);
}
public JsonResult getJSONProjects()
{
List<tblProject> listOfProjects = new List<tblProject>();
tblProjectDap newDap = new tblProjectDap();
listOfProjects = newDap.GetAllOrderByfldProjectTreeID();
return Json(listOfProjects, JsonRequestBehavior.AllowGet);
}
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);
}
public List<tblProject> GettblProjectByfldResponsibleEmployee(Int64 fldResponsibleEmployee)
{
using (var dap = new tblProjectDap(this))
{
return dap.GetByfldResponsibleEmployee(fldResponsibleEmployee);
}
}
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;
}
}
//
// GET: /Projects/Delete/5
public ActionResult Delete(int id)
{
tblProjectDap newDap = new tblProjectDap();
newDap.Delete(id);
return RedirectToAction("Index");
}
