public ActionResult UpdateWorkDesc(vm_workDesc workDescUpdate) { db.Database.ExecuteSqlCommand("UPDATE tbl_dailyReportTimeEntry SET workDescription={1}, workDescriptionCategory={2}, hours={3} WHERE timeEntryID={0}", workDescUpdate.timeEntryID, workDescUpdate.workDescription, workDescUpdate.workDescriptionCategory, workDescUpdate.hours); return(new EmptyResult()); }
public ActionResult UpdateWorkDesc(vm_workDesc workDescUpdate) { db.Database.ExecuteSqlCommand("UPDATE tbl_dailyReportTimeEntry SET workDescription={1} WHERE timeEntryID={0}", workDescUpdate.timeEntryID, workDescUpdate.workDescription); return(RedirectToAction("Index")); }
public ActionResult AddTeamMember(vm_workDesc teamMemberAdd) { db.Database.ExecuteSqlCommand("Insert into tbl_dailyReportTimeEntryUsers Values({0},{1})", teamMemberAdd.timeEntryID, teamMemberAdd.userName); return(new EmptyResult()); }
public ActionResult AddWorkDesc(vm_workDesc workDescAdd) { //db.Database.ExecuteSqlCommand("Insert into tbl_dailyReportTimeEntry Values({0},{1})", // workDescAdd.dailyReportID, workDescAdd.workDescription); db.Database.ExecuteSqlCommand("IF NOT EXISTS(SELECT * FROM tbl_dailyReportTimeEntry WHERE dailyReportID = {0}) " + "BEGIN" + "DECLARE @id INT" + "INSERT INTO tbl_dailyReportTimeEntry VALUES({0}, {1})" + "SET @id = SCOPE_IDENTITY()" + "INSERT INTO tbl_dailyReportTimeEntryUsers(timeEntryID, userName) VALUES(@id, {2})" + "END" + "ELSE" + "BEGIN" + "SET @timeEntryID = " + "(SELECT tbl_dailyReportTimeEntry.timeEntryID" + "FROM tbl_dailyReportTimeEntry" + "WHERE" + "tbl_dailyReportTimeEntry.dailyReportID like {0})" + "INSERT INTO tbl_dailyReportTimeEntryUsers(timeEntryID, userName) VALUES(@timeEntryID, {2})" + "END)", workDescAdd.dailyReportID, workDescAdd.workDescription, workDescAdd.userName); return(new EmptyResult()); //return RedirectToAction("Home", "Index"); //return Redirect("/Home"); }
public ActionResult DeleteTeamMember(vm_workDesc teamMemberDelete) { db.Database.ExecuteSqlCommand("DELETE FROM tbl_dailyReportTimeEntryUsers " + "WHERE " + "timeEntryID=({0})" + "AND userName = ({1})", teamMemberDelete.timeEntryID, teamMemberDelete.userName); return(new EmptyResult()); }
public ActionResult AddWorkDescDelaysNarr(vm_workDesc workDescAdd) { db.Database.ExecuteSqlCommand( "INSERT INTO tbl_dailyReportTimeEntry VALUES({0}, {1}, {2}, {3}) ", workDescAdd.dailyReportID, workDescAdd.workDescription, workDescAdd.workDescriptionCategory, workDescAdd.hours); return(new EmptyResult()); }
public ActionResult AddWorkDescNarr(vm_workDesc workDescAdd) { //--IF THE DAILY REPORT DOESN'T ALREADY EXIST... db.Database.ExecuteSqlCommand( "INSERT INTO tbl_dailyReportTimeEntry VALUES({0}, {1}, {2}, {3}) ", workDescAdd.dailyReportID, workDescAdd.workDescription, workDescAdd.workDescriptionCategory, workDescAdd.hours); return(new EmptyResult()); }
public ActionResult AddWorkDesc(vm_workDesc workDescAdd) { //--IF THE DAILY REPORT DOESN'T ALREADY EXIST... db.Database.ExecuteSqlCommand ("DECLARE @id INT " + "DECLARE @timeEntryID INT " + "IF NOT EXISTS (SELECT * FROM tbl_dailyReportTimeEntry " + "WHERE " + "dailyReportID = {0} " + "AND " + "workDescription = {1} " + "AND " + "workDescriptionCategory ={3}) " + "BEGIN " + "INSERT INTO tbl_dailyReportTimeEntry VALUES({0}, {1}, {3}, {4}) " + "SET @id = SCOPE_IDENTITY() " + "INSERT INTO tbl_dailyReportTimeEntryUsers(timeEntryID, userName) VALUES(@id, {2}) " + "END " + //--IF THE DAILY REPORT DOES ALREADY EXIST... "ELSE " + "BEGIN " + "SET @timeEntryID = " + "(SELECT tbl_dailyReportTimeEntry.timeEntryID " + "FROM tbl_dailyReportTimeEntry " + "WHERE " + "tbl_dailyReportTimeEntry.dailyReportID like {0} " + "AND " + "workDescription = {1} " + "AND " + "workDescriptionCategory = {3}) " + "INSERT INTO tbl_dailyReportTimeEntryUsers(timeEntryID, userName) VALUES(@timeEntryID, {02}) " + "END", workDescAdd.dailyReportID, workDescAdd.workDescription, workDescAdd.userName, workDescAdd.workDescriptionCategory, workDescAdd.hours); return(new EmptyResult()); //return View(); //return RedirectToAction("Index"); //return RedirectToAction("Index", new { dailyReportID = workDescAdd.dailyReportID }); //return RedirectToAction("Index", "DailyReportByReportID", new { reportID = workDescAdd.dailyReportID}); }
// GET: workDesc public ActionResult Index(int dailyReportID) { List <vm_workDesc> workDescs = new List <vm_workDesc>(); string mainconn = ConfigurationManager.ConnectionStrings["allpaxServiceRecordEntities"].ConnectionString; SqlConnection sqlconn = new SqlConnection(mainconn); sqlconn.Open(); //begin string sqlquery1 = "SELECT tbl_dailyReportTimeEntry.dailyReportID, tbl_dailyReportTimeEntry.workDescription, " + "tbl_dailyReportTimeEntry.hours, tbl_dailyReportTimeEntry.timeEntryID " + "FROM tbl_dailyReportTimeEntry " + "WHERE " + "tbl_dailyReportTimeEntry.dailyReportID = @dailyReportID " + "AND " + "tbl_dailyReportTimeEntry.workDescriptionCategory = '2'"; SqlCommand sqlcomm1 = new SqlCommand(sqlquery1, sqlconn); sqlcomm1.Parameters.AddWithValue("@dailyReportID", dailyReportID); SqlDataAdapter sda1 = new SqlDataAdapter(sqlcomm1); DataTable dt1 = new DataTable(); sda1.Fill(dt1); foreach (DataRow dr1 in dt1.Rows) { vm_workDesc workDesc = new vm_workDesc(); workDesc.dailyReportID = (int)dr1[0]; workDesc.workDescription = dr1[1].ToString(); workDesc.hours = (int)dr1[2]; workDesc.timeEntryID = (int)dr1[3]; //workDesc.timeEntryID = (int) dr1[2]; workDesc.userNames = workDescUsersByTimeEntryID(workDesc.timeEntryID); workDesc.userShortNames = workDescUserShortNamesByTimeEntryID(workDesc.timeEntryID); workDescs.Add(workDesc); } //sqlconn.Close(); //end return(View(workDescs)); }
public ActionResult AddWorkDescWntyDelaysTeam(vm_workDesc workDescAdd) { db.Database.ExecuteSqlCommand( "DECLARE @timeEntryID INT " + "SET @timeEntryID = " + "(SELECT tbl_dailyReportTimeEntry.timeEntryID " + "FROM tbl_dailyReportTimeEntry " + "WHERE " + "tbl_dailyReportTimeEntry.dailyReportID like {0} " + "AND " + "workDescription = {1} " + "AND " + "workDescriptionCategory = {3}) " + "INSERT INTO tbl_dailyReportTimeEntryUsers(timeEntryID, userName) VALUES(@timeEntryID, {02}) ", workDescAdd.dailyReportID, workDescAdd.workDescription, workDescAdd.userName, workDescAdd.workDescriptionCategory); return(new EmptyResult()); }
public ActionResult DeleteWorkDesc(vm_workDesc workDescDelete) { db.Database.ExecuteSqlCommand("DELETE FROM tbl_dailyReportTimeEntry WHERE timeEntryID=({0})", workDescDelete.timeEntryID); return(RedirectToAction("Index")); }
// GET: workDesc public ActionResult Index(int dailyReportID) { List <vm_workDesc> workDescs = new List <vm_workDesc>(); string mainconn = ConfigurationManager.ConnectionStrings["allpaxServiceRecordEntities"].ConnectionString; SqlConnection sqlconn = new SqlConnection(mainconn); sqlconn.Open(); //begin string sqlquery1 = "SELECT tbl_dailyReportTimeEntry.dailyReportID, tbl_dailyReportTimeEntry.workDescription, " + "tbl_dailyReportTimeEntry.timeEntryID " + "FROM tbl_dailyReportTimeEntry " + "WHERE " + "tbl_dailyReportTimeEntry.dailyReportID = @dailyReportID " + "AND " + "tbl_dailyReportTimeEntry.workDescriptionCategory = '1'"; SqlCommand sqlcomm1 = new SqlCommand(sqlquery1, sqlconn); sqlcomm1.Parameters.AddWithValue("@dailyReportID", dailyReportID); SqlDataAdapter sda1 = new SqlDataAdapter(sqlcomm1); DataTable dt1 = new DataTable(); sda1.Fill(dt1); foreach (DataRow dr1 in dt1.Rows) { vm_workDesc workDesc = new vm_workDesc(); workDesc.dailyReportID = (int)dr1[0]; workDesc.workDescription = dr1[1].ToString(); workDesc.timeEntryID = (int)dr1[2]; workDesc.userNames = workDescUsersByTimeEntryID(workDesc.timeEntryID); workDesc.userShortNames = workDescUserShortNamesByTimeEntryID(workDesc.timeEntryID); workDescs.Add(workDesc); } //sqlconn.Close(); //end //var model = new EmailConfirmationModel(); //string html = ViewRenderer.RenderView("~/views/workDescPrint/index.cshtml", workDescs); //SmtpClient smtp = new SmtpClient(); //smtp.Host = "smtp.gmail.com"; //smtp.Port = 587; //smtp.EnableSsl = true; //smtp.DeliveryMethod = SmtpDeliveryMethod.Network; //smtp.UseDefaultCredentials = false; //smtp.Credentials = new NetworkCredential("*****@*****.**", "Allpax_1234"); //string body = html; //using (var message = new MailMessage("*****@*****.**", "*****@*****.**")) //{ // message.Subject = "Test"; // message.Body = body; // message.IsBodyHtml = true; // smtp.Send(message); //} return(View(workDescs)); }