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();
}
