public string startProject(string list)
{
string data = list.Substring(1, list.Length - 2);
string[] data1 = data.Split(',');
DatabaseEntities db = new DatabaseEntities();
int teamLead_id = (int)Session["UserID"];
int post_id = (int)Session["SelectedPostId"];
ProjectsTable pt = db.ProjectsTables.Where(r => r.teamLead_id == teamLead_id && r.post_id == post_id).FirstOrDefault();
if (pt != null)
{
Session["projectID"] = pt.project_id;
return("!! project is already started by you .....");
}
else
{
ProjectsTable obj = new ProjectsTable();
obj.teamLead_id = teamLead_id;
obj.post_id = post_id;
obj.startDate = System.DateTime.Today;
obj.endDate = System.DateTime.Today;
ProjectsTable obj2 = db.ProjectsTables.Add(obj);
db.SaveChanges();
int projectId = obj.project_id;
for (int i = 0; i < data1.Length; i++)
{
DatabaseEntities db2 = new DatabaseEntities();
teamMembersTable teamData = new teamMembersTable();
teamData.project_id = projectId;
teamData.user_id = int.Parse(data1[i]);
db2.teamMembersTables.Add(teamData);
db2.SaveChanges();
}
Session["projectID"] = projectId;
return("Successfully you project is initializad");
}
}
public bool approveRequest(int id)
{
try
{
DatabaseEntities db = new DatabaseEntities();
teamMembersTable obj = db.teamMembersTables.Find(id);
if (obj != null)
{
obj.request = true;
db.SaveChanges();
return(true);
}
else
{
return(false);
}
}catch (Exception e)
{
return(false);
}
}
public string addSelectedMembers(string list, int pid)
{
try
{
string data = list.Substring(1, list.Length - 2);
string[] data1 = data.Split(',');
for (int i = 0; i < data1.Length; i++)
{
DatabaseEntities db2 = new DatabaseEntities();
teamMembersTable teamData = new teamMembersTable();
teamData.project_id = pid;
teamData.user_id = int.Parse(data1[i]);
db2.teamMembersTables.Add(teamData);
db2.SaveChanges();
}
return("ok");
}
catch (Exception e)
{
return(e.Message);
}
}
