public int AddProjectPhase(ProjectPhaseModel phaseModel, int projectId) { ProjectDataAccess obj = new ProjectDataAccess(); var result = obj.AddProjectPhase(phaseModel, projectId); foreach (ProjectTaskModel taskModel in phaseModel.ProjectTasks) { AddProjectTask(taskModel, result); } return(result); }
public int UpdateProjectPhase(ProjectPhaseModel phaseModel) { int result = 0; try { using (SqlConnection conn = new SqlConnection(ConfigurationSettings.AppSettings["DBConnection"].ToString())) { using (SqlCommand cmd = new SqlCommand()) { cmd.CommandText = "UpdateProjectPhase"; cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@ProjectPhaseId", phaseModel.PhaseId); cmd.Parameters.AddWithValue("@PhaseNumber", 0); cmd.Parameters.AddWithValue("@Name", phaseModel.PhaseName); cmd.Parameters.AddWithValue("@Description", phaseModel.Description); cmd.Parameters.AddWithValue("@ExpectedStartDate", phaseModel.StartDate); cmd.Parameters.AddWithValue("@ExpectedEndDate", phaseModel.EndDate); cmd.Parameters.AddWithValue("@ActualStartDate", string.Empty); cmd.Parameters.AddWithValue("@ActualEndDate", string.Empty); cmd.Parameters.AddWithValue("@IsCompleted", false); cmd.Parameters.AddWithValue("@AddedBy", 1); cmd.Parameters.AddWithValue("@IsDeleted", false); cmd.Connection = conn; conn.Open(); using (SqlDataAdapter ada = new SqlDataAdapter(cmd)) { result = Convert.ToInt32(cmd.ExecuteScalar()); } conn.Close(); } } } catch (Exception ex) { //LogError(ex); } return(result); }
public int UpdateProjectPhase(ProjectPhaseModel phaseModel, int projectId) { ProjectDataAccess obj = new ProjectDataAccess(); var result = 0; if (phaseModel.PhaseId > 0) { result = phaseModel.PhaseId; obj.UpdateProjectPhase(phaseModel); } else { result = obj.AddProjectPhase(phaseModel, projectId); } foreach (ProjectTaskModel taskModel in phaseModel.ProjectTasks) { UpdateProjectTask(taskModel, result); } return(result); }
private ProjectModel MapProjectDetailsWithTasksAsList(DataSet ds) { var obj = new ProjectModel(); if (ds != null && ds.Tables.Count > 0) { DataTable dt = new DataTable(); dt = ds.Tables[0]; if (dt != null && dt.Rows.Count > 0) { obj.ProjectId = Convert.ToInt32(dt.Rows[0]["ProjectId"]); obj.ProjectName = dt.Rows[0]["ProjectName"].ToString(); obj.PrimaryContactName = dt.Rows[0]["PrimaryContactName"].ToString(); obj.PrimaryNumber = dt.Rows[0]["PrimaryContactNumber"].ToString(); obj.Address = dt.Rows[0]["Address"].ToString(); obj.PinCode = dt.Rows[0]["PinCode"].ToString(); obj.Contact1Name = dt.Rows[0]["Contact1Name"].ToString(); obj.Contact1number = dt.Rows[0]["Contact1number"].ToString(); obj.Contact2Name = dt.Rows[0]["Contact2Name"].ToString(); obj.Contact2Number = dt.Rows[0]["Contact2Number"].ToString(); obj.Contact3Name = dt.Rows[0]["Contact3Name"].ToString(); obj.Contact3Number = dt.Rows[0]["Contact3Number"].ToString(); obj.StartDate = dt.Rows[0]["EstimatedStartDate"].ToString(); obj.EndDate = dt.Rows[0]["EstimatedEndDate"].ToString(); obj.IsHidden = Convert.ToBoolean(dt.Rows[0]["IsHidden"].ToString()); obj.EstimatedStartDate = Convert.ToDateTime(dt.Rows[0]["EstimatedStartDate"]).ToString("yyyy-MM-dd HH:mm"); obj.EstimatedEndDate = Convert.ToDateTime(dt.Rows[0]["EstimatedEndDate"]).ToString("yyyy-MM-dd HH:mm"); obj.ActualStartDate = Convert.ToDateTime(dt.Rows[0]["ActualStartDate"]).ToString("yyyy-MM-dd HH:mm"); obj.ActualEndDate = Convert.ToDateTime(dt.Rows[0]["ActualEndDate"]).ToString("yyyy-MM-dd HH:mm"); obj.ProjectEstimate = dt.Rows[0]["ProjectEstimate"].ToString(); obj.Comments = dt.Rows[0]["Comments"].ToString(); } if (ds.Tables.Count > 1) { DataTable dtPhases = new DataTable(); dtPhases = ds.Tables[1]; var projectPhases = new List <ProjectPhaseModel>(); foreach (DataRow drPhase in dtPhases.Rows) { var projectPhase = new ProjectPhaseModel(); projectPhase.PhaseName = drPhase["Name"].ToString(); projectPhase.PhaseId = Convert.ToInt32(drPhase["ProjectPhaseId"]); projectPhase.ProjectId = Convert.ToInt32(drPhase["ProjectId"]); projectPhase.StartDate = Convert.ToDateTime(drPhase["ExpectedStartDate"]).ToString("yyyy-MM-dd HH:mm"); projectPhase.EndDate = Convert.ToDateTime(drPhase["ExpectedEndDate"]).ToString("yyyy-MM-dd HH:mm"); projectPhase.Description = drPhase["Description"].ToString(); var dtTask = new DataTable(); dtTask = ds.Tables[2]; var tasks = from row in dtTask.AsEnumerable() where row.Field <int>("ProjectPhaseId") == projectPhase.PhaseId select row; var projectTasks = new List <ProjectTaskModel>(); foreach (DataRow drTask in tasks) { var task = new ProjectTaskModel(); task.ProjectPhaseId = projectPhase.PhaseId; task.StartDate = Convert.ToDateTime(drTask["ExpectedStartDate"]).ToString("yyyy-MM-dd HH:mm"); task.EndDate = Convert.ToDateTime(drTask["ExpectedEndDate"]).ToString("yyyy-MM-dd HH:mm"); task.TaskName = drTask["TaskName"].ToString(); task.ProjectTaskId = Convert.ToInt32(drTask["ProjectTaskId"]); task.Description = drTask["Description"].ToString(); projectTasks.Add(task); } projectPhase.ProjectTasks = projectTasks; projectPhases.Add(projectPhase); } obj.ProjectPhases = projectPhases; } } return(obj); }
public ProjectNumberModel() { ProjectPhase = new ProjectPhaseModel(); }