public JsonResult Delete(ProjectCreation projectCreation)
{
string strPassResult = "", strurl = "";
try
{
sqlCon.Open();
SqlCommand select_Project_Keys = new SqlCommand("select * from Tb_M_ProjectMapping where Id = '" + projectCreation.EmpId + "'", sqlCon);
SqlDataAdapter sqlDataAdapter = new SqlDataAdapter(select_Project_Keys);
DataSet Ds = new DataSet();
sqlDataAdapter.Fill(Ds);
int empid = Convert.ToInt32(Ds.Tables[0].Rows[0]["Id"]);
string strGrpOfProjectId = Ds.Tables[0].Rows[0]["ProjectIds"].ToString();
string[] GrpOfProjectIds = strGrpOfProjectId.Split(',');
if (GrpOfProjectIds.Contains(projectCreation.ProId.ToString()))
{
List<string> tempGrpOfProjectId = GrpOfProjectIds.ToList();
int tempindex = tempGrpOfProjectId.FindIndex(pro => pro == projectCreation.ProId.ToString());
tempGrpOfProjectId.RemoveAt(tempindex);
strGrpOfProjectId = string.Join(",", tempGrpOfProjectId);
}
SqlCommand SP_M_Project_delete = new SqlCommand("SP_M_Project_delete", sqlCon);
SP_M_Project_delete.CommandType = CommandType.StoredProcedure;
SP_M_Project_delete.Parameters.AddWithValue("@Id", projectCreation.ProId);
SP_M_Project_delete.Parameters.AddWithValue("@IsDeleted", 1);
int resultProject = SP_M_Project_delete.ExecuteNonQuery();
SqlCommand SP_M_ProjectMapping_update = new SqlCommand("SP_M_ProjectMapping_update", sqlCon);
SP_M_ProjectMapping_update.CommandType = CommandType.StoredProcedure;
SP_M_ProjectMapping_update.Parameters.AddWithValue("@Id", projectCreation.EmpId);
SP_M_ProjectMapping_update.Parameters.AddWithValue("@ProjectIds", strGrpOfProjectId);
int resultProjectMapping = SP_M_ProjectMapping_update.ExecuteNonQuery();
sqlCon.Close();
if (resultProject > 0 && resultProjectMapping > 0)
{
strPassResult = "Project deleted Successfully";
strurl = Url.Action("", "Project/CreateProject");
}
else
{
strPassResult = "Project not deleted Successfully";
}
}
catch (Exception e)
{
strPassResult = e.Message;
}
return Json(new {
msg = strPassResult,
url = strurl
});
}
public JsonResult getProjectDetails(int empId)
{
sqlCon.Open();
SqlCommand SP_M_getProjectid_ProjectMapping = new SqlCommand("SP_M_getProjectid_ProjectMapping", sqlCon);
SP_M_getProjectid_ProjectMapping.CommandType = CommandType.StoredProcedure;
SP_M_getProjectid_ProjectMapping.Parameters.AddWithValue("@Id", empId);
SqlDataReader dataReader = SP_M_getProjectid_ProjectMapping.ExecuteReader();
string strGroupOFProjectId = "";
while (dataReader.Read())
{
strGroupOFProjectId = dataReader["ProjectIds"].ToString();
}
dataReader.Close();
sqlCon.Close();
string[] GroupOFProjectIds = strGroupOFProjectId.Split(',');
List<ProjectCreation> LSProjects = new List<ProjectCreation> { };
for(int i = 0; i <= GroupOFProjectIds.Length - 2; i++)
{
SqlCommand SP_M_getProjectDetails = new SqlCommand("SP_M_getProjectDetails", sqlCon);
SP_M_getProjectDetails.CommandType = CommandType.StoredProcedure;
SP_M_getProjectDetails.Parameters.AddWithValue("@Id", GroupOFProjectIds[i]);
sqlCon.Open();
SqlDataReader dataReader_ProjectDetails = SP_M_getProjectDetails.ExecuteReader();
while (dataReader_ProjectDetails.Read())
{
ProjectCreation project = new ProjectCreation();
project.ProId = Convert.ToInt32(dataReader_ProjectDetails["Id"].ToString());
project.TaskName = dataReader_ProjectDetails["TaskName"].ToString();
var strBegindate = Convert.ToDateTime(dataReader_ProjectDetails["BeginDate"].ToString());
string[] strMonth = new string[] { "Jan", "Feb", "Mar", "Apr", "May", "Jun", "Jul", "Aug", "Sep", "Oct", "Nov", "Dec" };
project.strBeginDate = strBegindate.Day + " " + strMonth[strBegindate.Month - 1] + " " + strBegindate.Year;
project.Priority = dataReader_ProjectDetails["ProPriority"].ToString();
project.Status = dataReader_ProjectDetails["ProStatus"].ToString();
project.Resolution = dataReader_ProjectDetails["Resolution"].ToString();
project.DescCmt = dataReader_ProjectDetails["ProDescription"].ToString();
LSProjects.Add(project);
}
dataReader_ProjectDetails.Close();
sqlCon.Close();
}
return Json(new { msg = LSProjects }, JsonRequestBehavior.AllowGet);
}
public ActionResult CreateProject(ProjectCreation projectCreation)
{
sqlCon.Open();
SqlCommand SP_M_Project_update = new SqlCommand("SP_M_Project_update", sqlCon);
SP_M_Project_update.CommandType = CommandType.StoredProcedure;
SP_M_Project_update.Parameters.AddWithValue("@Id", projectCreation.ProId);
SP_M_Project_update.Parameters.AddWithValue("@TaskName", projectCreation.TaskName);
SP_M_Project_update.Parameters.AddWithValue("@BeginDate", projectCreation.BeginDate);
SP_M_Project_update.Parameters.AddWithValue("@ProPriority", projectCreation.Priority);
SP_M_Project_update.Parameters.AddWithValue("@ProStatus", projectCreation.Status);
SP_M_Project_update.Parameters.AddWithValue("@Resolution", projectCreation.Resolution);
SP_M_Project_update.Parameters.AddWithValue("@ProDescription", projectCreation.DescCmt);
SP_M_Project_update.Parameters.AddWithValue("@IsDeleted", 0);
int result = SP_M_Project_update.ExecuteNonQuery();
string strPassResult = "", strurl = "";
if (result >= 1)
{
strPassResult = "Project Created Successfully";
strurl = Url.Action("", "Project/CreateProject");
}
else
{
strPassResult = "Project not Create Successfully";
}
sqlCon.Close();
return Json(new
{
msg = strPassResult ,
url = strurl,
proId = projectCreation.EmpId
});
}
