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