public ActionResult Create([Bind(Include = "Deliverable_ID,Deliverable_deadline,Deliverable_end_date,Deliverable_start_date,Name,Budget,Estimated_manhours,Manhours_charged,Last_update,Last_update_by,Project_ID,Progress_status")] DELIVERABLE dELIVERABLE)
{
if (ModelState.IsValid)
{
var projectname = db.PROJECTs.FirstOrDefault(t => t.Project_ID == dELIVERABLE.Project_ID);
MailMessage message = new System.Net.Mail.MailMessage();
string fromEmail = "*****@*****.**";
string password = "******";
string toEmail = "*****@*****.**";
message.From = new MailAddress(fromEmail);
message.To.Add(toEmail);
message.Subject = "A new deliverable has been created.";
message.Body = String.Format("A deliverable called {0} has been created for project titled {1}.", dELIVERABLE.Name, projectname.Name);
message.DeliveryNotificationOptions = DeliveryNotificationOptions.OnFailure;
using (SmtpClient smtpClient = new SmtpClient("smtp.gmail.com", 587))
{
smtpClient.EnableSsl = true;
smtpClient.DeliveryMethod = SmtpDeliveryMethod.Network;
smtpClient.UseDefaultCredentials = false;
smtpClient.Credentials = new NetworkCredential(fromEmail, password);
smtpClient.Send(message.From.ToString(), message.To.ToString(), message.Subject, message.Body);
}
db.DELIVERABLES.Add(dELIVERABLE);
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.Project_ID = new SelectList(db.PROJECTs, "Project_ID", "Name", dELIVERABLE.Project_ID);
return(View(dELIVERABLE));
}
public ActionResult Create([Bind(Include = "Client_project_ID,Client_ID,Project_ID,Last_update,Last_update_by,Payment")] CLIENT_PROJECT cLIENT_PROJECT)
{
if (ModelState.IsValid)
{
var clientname = db.CLIENTs.FirstOrDefault(c => c.Client_ID == cLIENT_PROJECT.Client_ID);
var projectname = db.PROJECTs.FirstOrDefault(c => c.Project_ID == cLIENT_PROJECT.Project_ID);
MailMessage message = new System.Net.Mail.MailMessage();
string fromEmail = "*****@*****.**";
string password = "******";
string toEmail = "*****@*****.**";
message.From = new MailAddress(fromEmail);
message.To.Add(toEmail);
message.Subject = "A payment has been added for a client.";
message.Body = String.Format("A new payment of ${0} has been saved to the client-project association table for client {1} for project named {2}.", cLIENT_PROJECT.Payment, clientname.Name, projectname.Name);
message.DeliveryNotificationOptions = DeliveryNotificationOptions.OnFailure;
using (SmtpClient smtpClient = new SmtpClient("smtp.gmail.com", 587))
{
smtpClient.EnableSsl = true;
smtpClient.DeliveryMethod = SmtpDeliveryMethod.Network;
smtpClient.UseDefaultCredentials = false;
smtpClient.Credentials = new NetworkCredential(fromEmail, password);
smtpClient.Send(message.From.ToString(), message.To.ToString(), message.Subject, message.Body);
}
db.CLIENT_PROJECT.Add(cLIENT_PROJECT);
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.Client_ID = new SelectList(db.CLIENTs, "Client_ID", "Name", cLIENT_PROJECT.Client_ID);
ViewBag.Project_ID = new SelectList(db.PROJECTs, "Project_ID", "Name", cLIENT_PROJECT.Project_ID);
return(View(cLIENT_PROJECT));
}
public ActionResult Create([Bind(Include = "Name,Project_ID,USA_region,Deadline,Budget,Start_date,End_date,Progress_status,Last_update,Last_update_by,Department_ID,Manager_ID")] PROJECT pROJECT)
{
if (ModelState.IsValid)
{
MailMessage message = new System.Net.Mail.MailMessage();
string fromEmail = "*****@*****.**";
string password = "******";
string toEmail = "*****@*****.**";
message.From = new MailAddress(fromEmail);
message.To.Add(toEmail);
message.Subject = "A new project has been created.";
message.Body = String.Format("A project called {0} has been created.", pROJECT.Name);
message.DeliveryNotificationOptions = DeliveryNotificationOptions.OnFailure;
using (SmtpClient smtpClient = new SmtpClient("smtp.gmail.com", 587))
{
smtpClient.EnableSsl = true;
smtpClient.DeliveryMethod = SmtpDeliveryMethod.Network;
smtpClient.UseDefaultCredentials = false;
smtpClient.Credentials = new NetworkCredential(fromEmail, password);
smtpClient.Send(message.From.ToString(), message.To.ToString(), message.Subject, message.Body);
}
db.PROJECTs.Add(pROJECT);
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.Department_ID = new SelectList(db.DEPARTMENTs, "Dept_ID", "Name", pROJECT.Department_ID);
ViewBag.Manager_ID = new SelectList(db.EMPLOYEEs, "Employee_ID", "F_name", pROJECT.Manager_ID);
return(View(pROJECT));
}
public ActionResult Create([Bind(Include = "Client_ID,Name,EmailAddress,PhoneNumber,Last_Update,Last_Update_By")] CLIENT cLIENT)
{
if (ModelState.IsValid)
{
db.CLIENTs.Add(cLIENT);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(cLIENT));
}
public ActionResult Create([Bind(Include = "Name,Dept_ID,Last_update,Last_update_by")] DEPARTMENT dEPARTMENT)
{
if (ModelState.IsValid)
{
db.DEPARTMENTs.Add(dEPARTMENT);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(dEPARTMENT));
}
public ActionResult Create([Bind(Include = "Deliverable_ID,Deliverable_deadline,Deliverable_end_date,Deliverable_start_date,Name,Budget,Estimated_manhours,Manhours_charged,Last_update,Last_update_by,Project_ID,Progress_status")] DELIVERABLE dELIVERABLE)
{
if (ModelState.IsValid)
{
db.DELIVERABLES.Add(dELIVERABLE);
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.Project_ID = new SelectList(db.PROJECTs, "Project_ID", "Name", dELIVERABLE.Project_ID);
return(View(dELIVERABLE));
}
public ActionResult Create([Bind(Include = "Name,Project_ID,USA_region,Deadline,Budget,Start_date,End_date,Progress_status,Last_update,Last_update_by,Department_ID,Manager_ID")] PROJECT pROJECT)
{
if (ModelState.IsValid)
{
db.PROJECTs.Add(pROJECT);
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.Department_ID = new SelectList(db.DEPARTMENTs, "Dept_ID", "Name", pROJECT.Department_ID);
ViewBag.Manager_ID = new SelectList(db.EMPLOYEEs, "Employee_ID", "F_name", pROJECT.Manager_ID);
return(View(pROJECT));
}
public ActionResult Create([Bind(Include = "Timesheet_ID,Week,Hours,Last_update,Last_update_by,Employee_ID,Deliverable_ID")] TIMESHEET tIMESHEET)
{
if (ModelState.IsValid)
{
db.TIMESHEETs.Add(tIMESHEET);
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.Deliverable_ID = new SelectList(db.DELIVERABLES, "Deliverable_ID", "Name", tIMESHEET.Deliverable_ID);
ViewBag.Employee_ID = new SelectList(db.EMPLOYEEs, "Employee_ID", "F_name", tIMESHEET.Employee_ID);
return(View(tIMESHEET));
}
public ActionResult Create([Bind(Include = "Client_project_ID,Client_ID,Project_ID,Last_update,Last_update_by,Payment")] CLIENT_PROJECT cLIENT_PROJECT)
{
if (ModelState.IsValid)
{
db.CLIENT_PROJECT.Add(cLIENT_PROJECT);
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.Client_ID = new SelectList(db.CLIENTs, "Client_ID", "Name", cLIENT_PROJECT.Client_ID);
ViewBag.Project_ID = new SelectList(db.PROJECTs, "Project_ID", "Name", cLIENT_PROJECT.Project_ID);
return(View(cLIENT_PROJECT));
}
public ActionResult Create([Bind(Include = "Employee_ID,F_name,Employee_type,Hourly_rate,M_name,L_name,Last_update,Last_update_by,Email_address")] EMPLOYEE eMPLOYEE)
{
if (ModelState.IsValid)
{
db.EMPLOYEEs.Add(eMPLOYEE);
db.SaveChanges();
return(RedirectToAction("Index"));
}
var getTypeList = db.EMPLOYEE_TYPES.ToList();
SelectList list = new SelectList(getTypeList, "TypeID", "Employee_Type");
ViewBag.employeetype = list;
ViewBag.Employee_ID = new SelectList(db.EMPLOYEE_DELIVERABLE, "Employee_deliverable_ID", "Last_update_by", eMPLOYEE.Employee_ID);
return(View(eMPLOYEE));
}
/// <summary>
/// Inserting Data.
/// </summary>
/// <param name="obj"></param>
public void InsertData(ChangePasswordTBL obj)
{
ProjectManagementSystemEntities ent = new ProjectManagementSystemEntities();
ent.ChangePasswordTBLs.AddObject(obj);
ent.SaveChanges();
}
/// <summary>
/// Delete Attendence from the Attendence Grid view in HR Panel.
/// </summary>
/// <param name="id"></param>
public void deleteAttendence(int id)
{
ProjectManagementSystemEntities ent = new ProjectManagementSystemEntities();
AttendenceMaster obj = (from a in ent.AttendenceMasters where a.EmpId == id select a).FirstOrDefault();
if (obj != null)
{
ent.AttendenceMasters.DeleteObject(obj);
ent.SaveChanges();
}
}
/// <summary>
/// Insert new Record.
/// </summary>
/// <param name="obj"></param>
public void InsertData(TaskAssigned obj)
{
ProjectManagementSystemEntities ent = new ProjectManagementSystemEntities();
TaskAssigned objT = (from a in ent.TaskAssigneds where a.EmpId == obj.EmpId && a.TaskId == obj.TaskId select a).FirstOrDefault();
if (objT == null)
{
ent.TaskAssigneds.AddObject(obj);
ent.SaveChanges();
}
}
/// <summary>
/// Delete Data for client grid view.
/// </summary>
/// <param name="id"></param>
public void deleteClientdata(int id)
{
ProjectManagementSystemEntities ent = new ProjectManagementSystemEntities();
Client objclnt = (from a in ent.Clients where a.ClientId == id select a).FirstOrDefault();
if (objclnt != null)
{
ent.Clients.DeleteObject(objclnt);
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();
}
}
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();
}
}
/// <summary>
/// Deleting Record.
/// </summary>
/// <param name="id"></param>
public void DeleteData(int id)
{
ProjectManagementSystemEntities ent = new ProjectManagementSystemEntities();
TaskAssigned obj = (from a in ent.TaskAssigneds where a.TaskId == id select a).FirstOrDefault();
if (obj != null)
{
ent.TaskAssigneds.DeleteObject(obj);
ent.SaveChanges();
}
}
public ActionResult Create([Bind(Include = "Employee_ID,F_name,Employee_type,Hourly_rate,M_name,L_name,Last_update,Last_update_by,Email_address")] EMPLOYEE eMPLOYEE)
{
if (ModelState.IsValid)
{
string userId = User.Identity.GetUserId();
var user = (new ApplicationDbContext()).Users.FirstOrDefault(s => s.Id == userId);
MailMessage message = new System.Net.Mail.MailMessage();
string fromEmail = "*****@*****.**";
string password = "******";
string toEmail = "*****@*****.**";
message.From = new MailAddress(fromEmail);
message.To.Add(toEmail);
message.Subject = "A new employee has been created.";
message.Body = String.Format("An employeed named {0} {1} has been created in the EMPLOYEE table by manager of username {2}.", eMPLOYEE.F_name, eMPLOYEE.L_name, user.UserName);
message.DeliveryNotificationOptions = DeliveryNotificationOptions.OnFailure;
using (SmtpClient smtpClient = new SmtpClient("smtp.gmail.com", 587))
{
smtpClient.EnableSsl = true;
smtpClient.DeliveryMethod = SmtpDeliveryMethod.Network;
smtpClient.UseDefaultCredentials = false;
smtpClient.Credentials = new NetworkCredential(fromEmail, password);
smtpClient.Send(message.From.ToString(), message.To.ToString(), message.Subject, message.Body);
}
db.EMPLOYEEs.Add(eMPLOYEE);
db.SaveChanges();
return(RedirectToAction("Index"));
}
var getTypeList = db.EMPLOYEE_TYPES.ToList();
SelectList list = new SelectList(getTypeList, "TypeID", "Employee_Type");
ViewBag.employeetype = list;
ViewBag.Employee_ID = new SelectList(db.EMPLOYEE_DELIVERABLE, "Employee_deliverable_ID", "Last_update_by", eMPLOYEE.Employee_ID);
ViewBag.Employee_ID = new SelectList(db.User_login, "Employee_ID", "Username", eMPLOYEE.Employee_ID);
return(View(eMPLOYEE));
}
/// <summary>
/// Inserts new project Assigned data.
/// </summary>
/// <param name="obj"></param>
public void InsertData(ProjectAssigned obj)
{
ProjectManagementSystemEntities ent = new ProjectManagementSystemEntities();
ProjectAssigned objp = (from a in ent.ProjectAssigneds where a.ProjectId == obj.ProjectId && a.ProjectManagerId == obj.ProjectManagerId select a).FirstOrDefault();
if (objp == null)
{
//objp.ProjectId = obj.ProjectId;
//objp.ProjectManagerId = obj.ProjectManagerId;
ent.ProjectAssigneds.AddObject(obj);
ent.SaveChanges();
}
}
/// <summary>
/// Update Data for Client.
/// </summary>
/// <param name="objclnt"></param>
public void updateClientdata(Client objclnt)
{
ProjectManagementSystemEntities ent = new ProjectManagementSystemEntities();
Client objclntupdate = (from a in ent.Clients where a.ClientId == objclnt.ClientId select a).FirstOrDefault();
if (objclntupdate != null)
{
objclntupdate.FirstName = objclnt.FirstName;
objclntupdate.LastName = objclnt.LastName;
objclntupdate.MiddelName = objclnt.MiddelName;
objclntupdate.Mobile = objclnt.Mobile;
objclntupdate.Email = objclnt.Email;
objclntupdate.ModifyDate = objclnt.ModifyDate;
objclntupdate.ModifyBy = objclnt.ModifyBy;
ent.SaveChanges();
}
}
/// <summary>
/// Add New Client
/// </summary>
/// <param name="objclnt"></param>
public void AddNewClient(Client objclnt)
{
ProjectManagementSystemEntities ent = new ProjectManagementSystemEntities();
Client obj = new Client();
obj.FirstName = objclnt.FirstName;
obj.MiddelName = objclnt.MiddelName;
obj.LastName = objclnt.LastName;
obj.Mobile = objclnt.Mobile;
obj.Email = objclnt.Email;
obj.CreateDate = objclnt.CreateDate;
obj.CreateBy = objclnt.CreateBy;
obj.IsActive = objclnt.IsActive;
obj.IsDelete = objclnt.IsDelete;
ent.Clients.AddObject(obj);
ent.SaveChanges();
}
/// <summary>
/// Performs Day Entry for All employees.
/// </summary>
/// <param name="obj"></param>
/// <param name="ent"></param>
/// <param name="flag"></param>
public void DayEntry(AttendenceMaster obj, ProjectManagementSystemEntities ent, int flag)
{
DateTime now = DateTime.Now;
int date = Convert.ToDateTime(now.Date).Day;
switch (date)
{
case 1:
if (flag == 1)
{
obj.Day1 = true;
ent.SaveChanges();
}
else if (flag == 0)
{
obj.Day1 = true;
ent.AttendenceMasters.AddObject(obj);
ent.SaveChanges();
}
break;
case 2:
if (flag == 1)
{
obj.Day2 = true;
ent.SaveChanges();
}
else if (flag == 0)
{
obj.Day2 = true;
ent.AttendenceMasters.AddObject(obj);
ent.SaveChanges();
}
break;
case 3:
if (flag == 1)
{
obj.Day3 = true;
ent.SaveChanges();
}
else if (flag == 0)
{
obj.Day3 = true;
ent.AttendenceMasters.AddObject(obj);
ent.SaveChanges();
}
break;
case 4:
if (flag == 1)
{
obj.Day4 = true;
ent.SaveChanges();
}
else if (flag == 0)
{
obj.Day4 = true;
ent.AttendenceMasters.AddObject(obj);
ent.SaveChanges();
}
break;
case 5:
if (flag == 1)
{
obj.Day5 = true;
ent.SaveChanges();
}
else if (flag == 0)
{
obj.Day5 = true;
ent.AttendenceMasters.AddObject(obj);
ent.SaveChanges();
}
break;
case 6:
if (flag == 1)
{
obj.Day6 = true;
ent.SaveChanges();
}
else if (flag == 0)
{
obj.Day6 = true;
ent.AttendenceMasters.AddObject(obj);
ent.SaveChanges();
}
break;
case 7:
if (flag == 1)
{
obj.Day7 = true;
ent.SaveChanges();
}
else if (flag == 0)
{
obj.Day7 = true;
ent.AttendenceMasters.AddObject(obj);
ent.SaveChanges();
}
break;
case 8:
if (flag == 1)
{
obj.Day8 = true;
ent.SaveChanges();
}
else if (flag == 0)
{
obj.Day8 = true;
ent.AttendenceMasters.AddObject(obj);
ent.SaveChanges();
}
break;
case 9:
if (flag == 1)
{
obj.Day9 = true;
ent.SaveChanges();
}
else if (flag == 0)
{
obj.Day9 = true;
ent.AttendenceMasters.AddObject(obj);
ent.SaveChanges();
}
break;
case 10:
if (flag == 1)
{
obj.Day10 = true;
ent.SaveChanges();
}
else if (flag == 0)
{
obj.Day10 = true;
ent.AttendenceMasters.AddObject(obj);
ent.SaveChanges();
}
break;
case 11:
if (flag == 1)
{
obj.Day11 = true;
ent.SaveChanges();
}
else if (flag == 0)
{
obj.Day11 = true;
ent.AttendenceMasters.AddObject(obj);
ent.SaveChanges();
}
break;
case 12:
if (flag == 1)
{
obj.Day12 = true;
ent.SaveChanges();
}
else if (flag == 0)
{
obj.Day12 = true;
ent.AttendenceMasters.AddObject(obj);
ent.SaveChanges();
}
break;
case 13:
if (flag == 1)
{
obj.Day13 = true;
ent.SaveChanges();
}
else if (flag == 0)
{
obj.Day13 = true;
ent.AttendenceMasters.AddObject(obj);
ent.SaveChanges();
}
break;
case 14:
if (flag == 1)
{
obj.Day14 = true;
ent.SaveChanges();
}
else if (flag == 0)
{
obj.Day14 = true;
ent.AttendenceMasters.AddObject(obj);
ent.SaveChanges();
}
break;
case 15:
if (flag == 1)
{
obj.Day15 = true;
ent.SaveChanges();
}
else if (flag == 0)
{
obj.Day15 = true;
ent.AttendenceMasters.AddObject(obj);
ent.SaveChanges();
}
break;
case 16:
if (flag == 1)
{
obj.Day16 = true;
ent.SaveChanges();
}
else if (flag == 0)
{
obj.Day16 = true;
ent.AttendenceMasters.AddObject(obj);
ent.SaveChanges();
}
break;
case 17:
if (flag == 1)
{
obj.Day17 = true;
ent.SaveChanges();
}
else if (flag == 0)
{
obj.Day17 = true;
ent.AttendenceMasters.AddObject(obj);
ent.SaveChanges();
}
break;
case 18:
if (flag == 1)
{
obj.Day18 = true;
ent.SaveChanges();
}
else if (flag == 0)
{
obj.Day18 = true;
ent.AttendenceMasters.AddObject(obj);
ent.SaveChanges();
}
break;
case 19:
if (flag == 1)
{
obj.Day19 = true;
ent.SaveChanges();
}
else if (flag == 0)
{
obj.Day19 = true;
ent.AttendenceMasters.AddObject(obj);
ent.SaveChanges();
}
break;
case 20:
if (flag == 1)
{
obj.Day20 = true;
ent.SaveChanges();
}
else if (flag == 0)
{
obj.Day20 = true;
ent.AttendenceMasters.AddObject(obj);
ent.SaveChanges();
}
break;
case 21:
if (flag == 1)
{
obj.Day21 = true;
ent.SaveChanges();
}
else if (flag == 0)
{
obj.Day21 = true;
ent.AttendenceMasters.AddObject(obj);
ent.SaveChanges();
}
break;
case 22:
if (flag == 1)
{
obj.Day22 = true;
ent.SaveChanges();
}
else if (flag == 0)
{
obj.Day22 = true;
ent.AttendenceMasters.AddObject(obj);
ent.SaveChanges();
}
break;
case 23:
if (flag == 1)
{
obj.Day23 = true;
ent.SaveChanges();
}
else if (flag == 0)
{
obj.Day23 = true;
ent.AttendenceMasters.AddObject(obj);
ent.SaveChanges();
}
break;
case 24:
if (flag == 1)
{
obj.Day24 = true;
ent.SaveChanges();
}
else if (flag == 0)
{
obj.Day24 = true;
ent.AttendenceMasters.AddObject(obj);
ent.SaveChanges();
}
break;
case 25:
if (flag == 1)
{
obj.Day25 = true;
ent.SaveChanges();
}
else if (flag == 0)
{
obj.Day25 = true;
ent.AttendenceMasters.AddObject(obj);
ent.SaveChanges();
}
break;
case 26:
if (flag == 1)
{
obj.Day26 = true;
ent.SaveChanges();
}
else if (flag == 0)
{
obj.Day26 = true;
ent.AttendenceMasters.AddObject(obj);
ent.SaveChanges();
}
break;
case 27:
if (flag == 1)
{
obj.Day27 = true;
ent.SaveChanges();
}
else if (flag == 0)
{
obj.Day27 = true;
ent.AttendenceMasters.AddObject(obj);
ent.SaveChanges();
}
break;
case 28:
if (flag == 1)
{
obj.Day28 = true;
ent.SaveChanges();
}
else if (flag == 0)
{
obj.Day28 = true;
ent.AttendenceMasters.AddObject(obj);
ent.SaveChanges();
}
break;
case 29:
if (flag == 1)
{
obj.Day29 = true;
ent.SaveChanges();
}
else if (flag == 0)
{
obj.Day29 = true;
ent.AttendenceMasters.AddObject(obj);
ent.SaveChanges();
}
break;
case 30:
if (flag == 1)
{
obj.Day30 = true;
ent.SaveChanges();
}
else if (flag == 0)
{
obj.Day30 = true;
ent.AttendenceMasters.AddObject(obj);
ent.SaveChanges();
}
break;
case 31:
if (flag == 1)
{
obj.Day31 = true;
ent.SaveChanges();
}
else if (flag == 0)
{
obj.Day31 = true;
ent.AttendenceMasters.AddObject(obj);
ent.SaveChanges();
}
break;
}
}
