public int GetModuleId(int Empid)
{
ProjectManagementSystemEntities ent = new ProjectManagementSystemEntities();
ModuleAssigned obj = (from a in ent.ModuleAssigneds where a.TeamLeaderId == Empid select a).FirstOrDefault();
return(Convert.ToInt32(obj.ModuleId));
}
public void deleteModuledata(int ID)
{
ProjectManagementSystemEntities ent = new ProjectManagementSystemEntities();
ModuleAssigned obj = (from a in ent.ModuleAssigneds where a.Id == ID select a).FirstOrDefault();
if (obj != null)
{
ent.ModuleAssigneds.DeleteObject(obj);
ent.SaveChanges();
}
}
public void InsertData(ModuleAssigned obj)
{
ProjectManagementSystemEntities ent = new ProjectManagementSystemEntities();
ModuleAssigned objM = (from a in ent.ModuleAssigneds where a.TeamLeaderId == obj.TeamLeaderId && a.ModuleId == obj.ModuleId select a).FirstOrDefault();
if (objM == null)
{
ent.ModuleAssigneds.AddObject(obj);
ent.SaveChanges();
}
}
