public ActionResult AddTask()
{
Project_Property objtimeline = new Project_Property();
ProjectType_BLL objProjectTypeBLL = new ProjectType_BLL();
objProjectProperty = new Project_Property();
objProjectBll = new Project_BLL(objProjectProperty);
DataTable projects = objProjectBll.SelectAll();
List <Project_Property> ProjectType_PropertylistItems = new List <Project_Property>();
foreach (DataRow dr in projects.Rows)
{
Project_Property objProjectType_Property = new Project_Property();
objProjectType_Property.Project_Name = dr["Project_Name"].ToString();
objProjectType_Property.Project_Id = Convert.ToInt32(dr["Project_Id"].ToString());
ProjectType_PropertylistItems.Add(objProjectType_Property);
}
objtimeline.Start_Date = DateTime.Now;
objtimeline.Expected_completedDate = DateTime.Now;
objtimeline.Project_Item = ProjectType_PropertylistItems;
GetEmployee();
GetMilestones();
return(View(objtimeline));
}
// GET: Project
public ActionResult AddProject()
{
GetDepartments();
GetClients();
GetProjectType();
GetEmployee();
ViewBag.projcttype = null;
objProjectProperty = new Project_Property();
objProjectProperty.Project_Id = 0;
objProjectProperty.Start_Date = DateTime.Now;
objProjectProperty.Expected_completedDate = DateTime.Now;
string projectid = RandomString(8);
if (CheckProjectID(projectid))
{
AddProject();
}
else
{
objProjectProperty.Proj_Id = projectid;
return(View("ProjectAdd", objProjectProperty));
}
return(View("ProjectAdd", objProjectProperty));
}
public bool CheckProjectID(string projid)
{
objProjectProperty = new Project_Property();
objProjectProperty.Proj_Id = projid;
objProjectBll = new Project_BLL(objProjectProperty);
return(objProjectBll.CheckProjectID());
}
public JsonResult AddProject(Project_Property Project)
{
if (ModelState.IsValid)
{
//add new employee
if (Project.Project_Id == null || Project.Project_Id <= 0)
{
Project.DateCreated = DateTime.Now;
Project.Status = "Active";
Project.Is_Active = true;
Project.In_Progress = false;
Project.Is_Completed = false;
Project.Remarks = "";
objProjectBll = new Project_BLL(Project);
var flag = objProjectBll.Insert();
if (flag)
{
return(Json(new { success = true, statuscode = 200, msg = "Successfully inserted" }, JsonRequestBehavior.AllowGet));
}
else
{
return(Json(new { success = false, statuscode = 500, msg = "Failed" }, JsonRequestBehavior.AllowGet));
}
}
//when id <0 update case
else
{
Project.DateCreated = DateTime.Now;
Project.Status = "Active";
Project.Is_Active = true;
Project.In_Progress = false;
Project.Is_Completed = false;
objProjectBll = new Project_BLL(Project);
var flag = objProjectBll.Update();
if (flag)
{
return(Json(new { success = true, statuscode = 200, msg = "Successfully inserted" }, JsonRequestBehavior.AllowGet));
}
else
{
return(Json(new { success = false, statuscode = 500, msg = "Failed" }, JsonRequestBehavior.AllowGet));
}
}
}
//when model state is not valid
else
{
var errors = ModelState.Select(x => x.Value.Errors)
.Where(y => y.Count > 0)
.ToList();
return(Json(new { success = false, statuscode = 500, msg = "Please Enter According To Instructions" }, JsonRequestBehavior.AllowGet));
}
}
public ActionResult GetProjectEstimationDetails(int id)
{
objProjectProperty = new Project_Property();
objProjectProperty.P_Id = id;
objProjectBll = new Project_BLL(objProjectProperty);
var estimation = JsonConvert.SerializeObject(objProjectBll.GetDetailsForProjectEstimation());
ViewBag.FooObj = estimation;
return(View());
}
public ActionResult ViewMilesStone(int id)
{
objProjectProperty = new Project_Property();
objProjectProperty.Project_Id = id;
objProjectBll = new Project_BLL(objProjectProperty);
DataTable dt = objProjectBll.GetAllMilestoneById();
var Milestones = JsonConvert.SerializeObject(dt);
ViewBag.Milestone = Milestones;
return(View());
}
public ActionResult AssignedProjectDetails(int id)
{
objProjectProperty = new Project_Property();
objProjectProperty.Project_Id = id;
objProjectBll = new Project_BLL(objProjectProperty);
DataTable dt = objProjectBll.SelectOne().Tables[1];
ViewBag.starttime = dt.Rows.Count > 0 ? false : true;
return(View(objProjectProperty));
}
public JsonResult GetCompletedProjects()
{
objProjectProperty = new Project_Property();
objProjectProperty.Resource_Id = Convert.ToInt32(SessionManager.CurrentUser.EmployeeID);
objProjectBll = new Project_BLL(objProjectProperty);
DataTable projects = objProjectBll.SelectAssignedCompletedProjectsForEmployee();
var projectsJson = JsonConvert.SerializeObject(projects);
var deserilize = JsonConvert.DeserializeObject(projectsJson);
return(Json(new { projectlist = projectsJson }, JsonRequestBehavior.AllowGet));
}
public JsonResult getProjects()
{
objProjectProperty = new Project_Property();
objProjectBll = new Project_BLL(objProjectProperty);
DataTable projects = objProjectBll.SelectAll();
var projectsJson = JsonConvert.SerializeObject(projects);
var deserilize = JsonConvert.DeserializeObject(projectsJson);
return(Json(new { projectlist = projectsJson }, JsonRequestBehavior.AllowGet));
}
public List <Project_Property> GetProjects()
{
Project_BLL objprojectbll = new Project_BLL();
DataTable dt = objprojectbll.SelectUnAssignedProjects();
List <Project_Property> objProject_Property = new List <Project_Property>();
foreach (DataRow dr in dt.Rows)
{
Project_Property objprojctpropert = new Project_Property();
objprojctpropert.Project_Id = Convert.ToInt32(dr["Project_Id"].ToString());
objprojctpropert.Project_Name = dr["Project_Name"].ToString();
objProject_Property.Add(objprojctpropert);
}
return(objProject_Property);
}
public ActionResult ShowProject(int id)
{
GetDepartments();
GetClients();
GetProjectType();
GetEmployee();
objProjectProperty = new Project_Property();
objProjectProperty.Project_Id = id;
//objClientProp.TableName = "tblClient";
objProjectBll = new Project_BLL(objProjectProperty);
DataTable dt = objProjectBll.SelectOneEdit();
ViewBag.Project = dt;
ViewBag.strtdate = objProjectProperty.Start_Date.ToString("yyyy-MM-dd");
ViewBag.wdate = objProjectProperty.Work_Date;
ViewBag.projcttype = objProjectProperty.Project_Type;
return(View("ProjectAdd", objProjectProperty));
}
public JsonResult DeleteProject(int id)
{
objProjectProperty = new Project_Property();
objProjectProperty.Project_Id = id;
// objProjectProperty.TableName = "tblClient";
objProjectProperty.Status = "Deleted";
// objClientProp.U_id = SessionManager.CurrentUser.ID;
objProjectBll = new Project_BLL(objProjectProperty);
var flag = objProjectBll.UpdateStatus();
if (flag)
{
return(Json(new { success = true, statuscode = 200, msg = "Successfull" }, JsonRequestBehavior.AllowGet));
}
else
{
return(Json(new { success = false, statuscode = 500, msg = "Failed" }, JsonRequestBehavior.AllowGet));
}
}
private void savetopproperty(HttpContext context)
{
string IDs = context.Request.Params["IDs"];
int ProjectID = WebUtil.GetIntValue(context, "ProjectID");
int CompanyID = WebUtil.GetIntValue(context, "CompanyID");
string SortOrders = context.Request.Params["SortOrders"];
string CheckLists = context.Request.Params["CheckLists"];
List <int> IDList = JsonConvert.DeserializeObject <List <int> >(IDs);
List <int> SortOrderList = JsonConvert.DeserializeObject <List <int> >(SortOrders);
List <int> CheckList = JsonConvert.DeserializeObject <List <int> >(CheckLists);
using (SqlHelper helper = new SqlHelper())
{
try
{
helper.BeginTransaction();
int i = 0;
foreach (var ID in IDList)
{
var projectProperty = Project_Property.GetProject_Property(ProjectID, ID, helper);
if (projectProperty == null)
{
projectProperty = new Project_Property();
projectProperty.ProjectID = ProjectID;
projectProperty.RelationID = ID;
projectProperty.AddTime = DateTime.Now;
}
projectProperty.SortOrder = SortOrderList[i];
projectProperty.IsHide = CheckList[i] == 1 ? false : true;
projectProperty.Save(helper);
i++;
}
helper.Commit();
WebUtil.WriteJson(context, new { status = true });
}
catch (Exception ex)
{
helper.Rollback();
LogHelper.WriteError("ProjectPropertyHandler", "visit: savetopproperty", ex);
WebUtil.WriteJson(context, new { status = false });
}
}
}
public ActionResult AddTimeLine()
{
TimeLine_Property objtimeline = new TimeLine_Property();
objtimeline.Project_Item = GetProjects();
objProjectProperty = new Project_Property();
objProjectBll = new Project_BLL(objProjectProperty);
DataTable projects = objProjectBll.SelectAll();
List <Project_Property> ProjectType_PropertylistItems = new List <Project_Property>();
foreach (DataRow dr in projects.Rows)
{
Project_Property objProjectType_Property = new Project_Property();
objProjectType_Property.Project_Name = dr["Project_Name"].ToString();
objProjectType_Property.Project_Id = Convert.ToInt32(dr["Project_Id"].ToString());
ProjectType_PropertylistItems.Add(objProjectType_Property);
}
objtimeline.Project_Item = ProjectType_PropertylistItems;
return(View(objtimeline));
}
private void deleteproperty(HttpContext context)
{
int ProjectID = WebUtil.GetIntValue(context, "ProjectID");
int PropertyID = WebUtil.GetIntValue(context, "PropertyID");
using (SqlHelper helper = new SqlHelper())
{
try
{
helper.BeginTransaction();
Project project = Project.GetProject(ProjectID, helper);
if (project.ID != 1 && project.ParentID != 1)
{
context.Response.Write("2");
return;
}
var projectProperty = Project_Property.GetProject_Property(ProjectID, PropertyID, helper);
if (projectProperty == null)
{
projectProperty = new Project_Property();
projectProperty.ProjectID = ProjectID;
projectProperty.RelationID = PropertyID;
projectProperty.AddTime = DateTime.Now;
}
projectProperty.IsHide = true;
projectProperty.Save(helper);
helper.Commit();
}
catch (Exception ex)
{
helper.Rollback();
LogHelper.WriteError("ProjectPropertyHandler", "visit: deleteproperty", ex);
context.Response.Write("1");
return;
}
}
context.Response.Write("0");
}
public Project_BLL(Project_Property property)
{
objprojectproperty = property;
}
private void addproperty(HttpContext context)
{
try
{
string strjson = context.Request.Form["strjson"];
int ProjectID = int.Parse(context.Request.Params["ProjectID"]);
List <string> list = JsonConvert.DeserializeObject <List <string> >(strjson);
Project project = Project.GetProject(ProjectID);
string PName = string.Empty;
List <int> idlist = new List <int>();
int count = 0;
ProjectProperty property = new ProjectProperty();
property.AddTime = DateTime.Now;
property.MainSortOrder = 0;
property.IsBelongProject = true;
PropertyInfo[] propertylist = property.GetType().GetProperties();
for (int i = 0; i < list.Count; i++)
{
if (string.IsNullOrEmpty(list[i]))
{
continue;
}
count++;
if (count == 1)
{
property.Title = string.IsNullOrEmpty(project.PName) ? list[i] : project.PName;
}
PropertyInfo info = propertylist.FirstOrDefault(p => p.Name.Equals("Level" + (count - 1)));
if (info != null)
{
info.SetValue(property, list[i], null);
}
}
var project_property = new Project_Property();
project_property.ProjectID = ProjectID;
project_property.SortOrder = 1;
project_property.IsHide = false;
project_property.AddTime = DateTime.Now;
using (SqlHelper helper = new SqlHelper())
{
try
{
helper.BeginTransaction();
property.Save(helper);
project_property.RelationID = property.ID;
project_property.Save(helper);
helper.Commit();
context.Response.Write("0");
}
catch (Exception ex)
{
helper.Rollback();
LogHelper.WriteError("ProjectPropertyHandler", "visit: addproperty", ex);
context.Response.Write("1");
}
}
}
catch (Exception ex)
{
LogHelper.WriteError("ProjectPropertyHandler", "visit: addproperty", ex);
context.Response.Write("1");
}
}
public JsonResult AddTask(Project_Property Project)
{
if (ModelState.IsValid)
{
EmployeeProperty objempproperty = new EmployeeProperty();
objempproperty.Id = Project.Resource_Id;
Employee_BLL objemployeebll = new Employee_BLL(objempproperty);
DataTable dt = objemployeebll.SelectOne();
foreach (DataRow dr in dt.Rows)
{
Project.Employee_Cost = Math.Round(Convert.ToDecimal(dr["TotalSalary"].ToString()) / 270, 2);
}
//add new employee
if (Project.Project_Id == null || Project.Project_Id <= 0)
{
Project.DateCreated = DateTime.Now;
Project.Status = "Active";
Project.Is_Active = true;
Project.In_Progress = false;
Project.Is_Completed = false;
Project.Remarks = "";
//Project.Employee_Cost=
objProjectBll = new Project_BLL(Project);
var flag = objProjectBll.InsertTask();
if (flag)
{
return(Json(new { success = true, statuscode = 200, msg = "Successfully inserted" }, JsonRequestBehavior.AllowGet));
}
else
{
return(Json(new { success = false, statuscode = 500, msg = "Failed" }, JsonRequestBehavior.AllowGet));
}
}
//when id <0 update case
else
{
Project.DateCreated = DateTime.Now;
Project.Status = "Active";
objProjectBll = new Project_BLL(Project);
var flag = objProjectBll.Insert();
if (flag)
{
return(Json(new { success = true, statuscode = 200, msg = "Successfully inserted" }, JsonRequestBehavior.AllowGet));
}
else
{
return(Json(new { success = false, statuscode = 500, msg = "Failed" }, JsonRequestBehavior.AllowGet));
}
}
}
//when model state is not valid
else
{
var errors = ModelState.Select(x => x.Value.Errors)
.Where(y => y.Count > 0)
.ToList();
return(Json(new { success = false, statuscode = 500, msg = "Please Enter According To Instructions" }, JsonRequestBehavior.AllowGet));
}
}
