public long Insert(DayOff entity) { entity.Date = DateTime.Now; db.DayOffs.Add(entity); db.SaveChanges(); return(entity.ID); }
public void AddStudent(string userId) { var student = new Student { UserId = userId }; db.Students.Add(student); db.SaveChanges(); }
public void RemoveUser(string userId, int eventId, int positionId) { var remove = this.dbSet.First(u => u.UserId == userId && u.PositionId == positionId && u.EventId == eventId ); this.dbSet.Remove(remove); dbContext.SaveChanges(); }
public long Insert(ViolatorKTV entity) { int a = 0; string[] arrEmpId = string.Join(",", entity.SelectedIDArray).Replace(" ", "").Split(','); for (int i = 0; i < arrEmpId.Length; i++) { entity.Employee_ID = Int32.Parse(arrEmpId[i]); entity.TimeOut = entity.TimeIn.AddHours(12); db.ViolatorKTVs.Add(entity); db.SaveChanges(); a = 1; } return(a); }
public ActionResult Index() { var callback = string.Format("http://localhost:57498/home/{0}", nameof(Callback)); var response = clientSubscriber.Subscribe(callback); webAppDbContext.Tokens.Add(new Token { Value = response.Token, Expires = response.Expires }); webAppDbContext.SaveChanges(); return(View()); }
public ActionResult Edit(string id, tbl_MCAT tbl_MCAT) { try { if (id == null) { return new HttpStatusCodeResult(HttpStatusCode.BadRequest); } // TODO: Add update logic here using (WebAppDbContext db = new WebAppDbContext()) { if (!ModelState.IsValid) { return PartialView("_Edit"); } db.Entry(tbl_MCAT).State = System.Data.Entity.EntityState.Modified; db.SaveChanges(); } Alert("Record Updated Sucessfully!!!", NotificationType.success); return RedirectToAction("Index"); } catch { Alert("Their is something went wrong!!!", NotificationType.error); return RedirectToAction("Index"); } }
public async Task ConfirmMessage(string messageUUID, string sender, bool messageRead) { //var message = _context.Message.Where(m => m.Id.ToString() == messageUUID).FirstOrDefault(); //if(message == null) //{ // _logger.Error($"Nie znaleziono wiadomości o UUID {messageUUID} ."); // return; //} //message.IsRead = true; //var result = await _context.SaveChangesAsync(); //if(result == 0) //{ // _logger.Error($"Nie powiodła się oznaczenie wiadomości o UUID {messageUUID} jako przeczytanej."); // return; //} if (messageRead) { _logger.Info($"Oznaczanie wiadomości o ID {messageUUID} jako przeczytanej."); var msg = _context.Message.Where(m => m.Id == new Guid(messageUUID)).FirstOrDefault(); if (msg == null) { _logger.Warn("Nie znaleziono wiadomości o ID " + messageUUID); } else { msg.IsRead = messageRead; _context.SaveChanges(); } } _logger.Info($"Potwierdzenie dostarczenia wiadomości o identyfikatorze {messageUUID}."); await Clients.User(sender).SendAsync("ConfirmMessageToSender", messageUUID); }
public ActionResult Create(M_PMS M_PMS) { string actionName = "Create"; try { _logger.Log(LogLevel.Trace, actionName + " :: started."); if (ModelState.IsValid) { using (WebAppDbContext db = new WebAppDbContext()) { db.M_PMS.Add(M_PMS); db.SaveChanges(); } _logger.Log(LogLevel.Trace, actionName + " :: ended."); Alert("Data Saved Sucessfully!!!", NotificationType.success); return(RedirectToAction("Index")); } else { _logger.Log(LogLevel.Trace, actionName + " :: ended."); return(PartialView("_Create")); } } catch (Exception ex) { _logger.Log(LogLevel.Error, actionName + " EXCEPTION :: " + ex.ToString() + " INNER EXCEPTION :: " + ex.InnerException?.ToString()); Alert("Their is something went wrong!!!", NotificationType.error); return(RedirectToAction("Index")); } }
public ActionResult Delete2(int id, FormCollection collection) { using (var db = new WebAppDbContext()) { using (var transaction = db.Database.BeginTransaction()) { try { if (id <= 0) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } var result = db.tbl_Parts.Where(x => x.PartId == id).SingleOrDefault(); if (result != null) { //Remove from award db.tbl_Parts.Remove(result); db.SaveChanges(); transaction.Commit(); } Alert("Record Deleted Permanently!!!", NotificationType.success); return(RedirectToAction("Index")); } catch (Exception ex) { transaction.Rollback(); Exception(ex); Alert("Their is something went wrong!!!", NotificationType.error); return(RedirectToAction("Index")); } } } }
public JsonResult SaveAsDashboard(string dashboardId, string userId, string roleId) { var type = "success"; var msg = "Dashboard added successfully"; try { using (var context = new WebAppDbContext()) { UserDashboardMapping model = new UserDashboardMapping() { DashboardId = dashboardId, UserId = userId, RoleId = roleId, IsDefault = "0", InsertionDateTime = DateTime.Now, InsertedBy = Session[SessionKeys.UserId].ToString() }; context.UserDashboardMappings.Add(model); context.SaveChanges(); } } catch (Exception ex) { type = "error"; msg = ex.ToString(); } return(Json(new { type = type, msg = msg }, JsonRequestBehavior.AllowGet)); }
public ActionResult Edit(int id, tbl_Cage tbl_Cage) { string actionName = "Edit"; _logger.Log(LogLevel.Trace, actionName + " :: started."); try { if (ModelState.IsValid) { if (id <= 0) { Alert("Invalid Cage Selected.", NotificationType.error); _logger.Log(LogLevel.Trace, actionName + " :: Ended. Invalid cage id : " + id); return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } using (var db = new WebAppDbContext()) { var cage = db.tbl_Cage.FirstOrDefault(x => x.CageId == id); if (cage != null && (cage?.CageCode == tbl_Cage.CageCode)) { cage.CageName = tbl_Cage.CageName; cage.Address = tbl_Cage.Address; cage.Country = tbl_Cage.Country; cage.City = tbl_Cage.City; cage.PostalCode = tbl_Cage.PostalCode; cage.Status = tbl_Cage.Status; cage.ModifiedByUser = Session[SessionKeys.UserId]?.ToString(); cage.ModifiedOnDate = DateTime.Now; db.Entry(cage).State = EntityState.Modified; db.SaveChanges(); Alert("Record Updated Successfully.", NotificationType.success); } else { Alert("Cage Not Found.", NotificationType.error); _logger.Log(LogLevel.Trace, actionName + " :: Ended. Cage not found for cage id : " + id); } } } else { _logger.Log(LogLevel.Trace, actionName + " :: Ended. Model state is not valid for cage id : " + id); CageViewModels objCageViewModels = GetCage(id); return(PartialView("_Edit", objCageViewModels)); } } catch (Exception ex) { Alert("Something Went Wrong !!!", NotificationType.error); _logger.Log(LogLevel.Error, actionName + " EXCEPTION :: " + ex.ToString() + " INNER EXCEPTION :: " + ex.InnerException?.ToString()); Exception(ex); } return(RedirectToAction("Index")); }
public ActionResult Create(tbl_Cage tbl_Cage) { string actionName = "Create"; _logger.Log(LogLevel.Trace, actionName + " :: started."); try { if (ModelState.IsValid) { using (var db = new WebAppDbContext()) { if (!db.tbl_Cage.Any(x => x.CageCode == tbl_Cage.CageCode)) { // Get Current user Id var userId = Session[SessionKeys.UserId]?.ToString(); tbl_Cage.CreatedByUser = userId; tbl_Cage.ModifiedByUser = userId; //Get Current Date & Time. tbl_Cage.CreatedOnDate = DateTime.Now; tbl_Cage.ModifiedOnDate = DateTime.Now; tbl_Cage.Status = "Active"; db.tbl_Cage.Add(tbl_Cage); db.SaveChanges(); Alert("Record Added Successfully !! ", NotificationType.success); } else { _logger.Log(LogLevel.Trace, actionName + " :: Cage code : " + tbl_Cage.CageCode + " already exist."); Alert("Cage code already exist.", NotificationType.error); } } } else { CageViewModels vm = new CageViewModels(); SessionKeys.LoadTablesInSession(SessionKeys.Countries, "", ""); vm._tbl_Country = ((List <ClassLibrary.Models.tbl_Country>)Session[SessionKeys.Countries]); _logger.Log(LogLevel.Trace, actionName + " :: Model state not valid."); return(PartialView("_Create", vm)); } } catch (Exception ex) { Alert("Their is something went wrong!!!", NotificationType.error); _logger.Log(LogLevel.Error, actionName + " EXCEPTION :: " + ex.ToString() + " INNER EXCEPTION :: " + ex.InnerException?.ToString()); Exception(ex); } _logger.Log(LogLevel.Trace, actionName + " :: ended."); return(RedirectToAction("Index")); }
public ActionResult Edit(tbl_Category category) { WebAppDbContext db = new WebAppDbContext(); db.Entry(category).State = System.Data.Entity.EntityState.Modified; db.SaveChanges(); return(RedirectToAction("List")); }
// Save Exception log in database public void Exception(Exception errorLogs) { ex.Message = errorLogs.Message?.ToString(); ex.StackTrace = errorLogs.StackTrace?.ToString(); ex.ExceptionType = errorLogs.GetType()?.Name?.ToString(); ex.LogTime = DateTime.Now; db.tbl_ErrorLogs.Add(ex); db.SaveChanges(); }
public ActionResult Delete(int id) { WebAppDbContext db = new WebAppDbContext(); var category = db.tbl_Category.Find(id); db.tbl_Category.Remove(category); db.SaveChanges(); return(RedirectToAction("List")); }
public bool Add(User user) { tbl_User us = new tbl_User(); us.UserId = user.UserId; us.UserName = user.UserName; us.Password = user.Password; us.Email = user.Email; us.Gender = user.Gender; us.IsInterestedInCSharp = user.IsInterestedInCSharp; us.IsInterestedInJava = user.IsInterestedInJava; us.IsInterestedInPython = user.IsInterestedInPython; us.CityId = user.CityId; us.DOB = user.DOB; db.tbl_User.Add(us); db.SaveChanges(); return(true); }
public ActionResult ReturnRequestSubmit(int?reqId) { using (var db = new WebAppDbContext()) { using (var transaction = db.Database.BeginTransaction()) { var vm = new ConfigViewModel(); try { if (reqId != null) { var result = db.tbl_Request.Where(x => x.RequestId == reqId).FirstOrDefault(); if (result != null) { result.Status = 1; db.SaveChanges(); transaction.Commit(); } tbl_RequestLog req = new tbl_RequestLog(); req.RequestId = reqId; req.Status = 1; req.Remarks = "Again Submitted"; req.CurrentDateTime = DateTime.Now; req.UserId = System.Web.HttpContext.Current.User.Identity.GetUserId(); db.tbl_RequestLog.Add(req); db.SaveChanges(); } // Alert("Record Deleted Sucessfully!!!", NotificationType.success); return(RedirectToAction("RequestReturn")); } catch (Exception ex) { transaction.Rollback(); Exception(ex); Alert("Their is something went wrong!!!", NotificationType.error); return(RedirectToAction("RequestReturn")); } } } }
public ActionResult EditMOP(M_MOPModel model, int?SiteId, string eswbs) { string actionName = "EditMOP"; _logger.Log(LogLevel.Trace, actionName + " :: started."); using (var db = new WebAppDbContext()) { using (var transaction = db.Database.BeginTransaction()) { MopViewModels vm = new MopViewModels(); try { if (!ModelState.IsValid) { _logger.Log(LogLevel.Trace, actionName + " :: ended."); Alert("Their is something went wrong!!!", NotificationType.error); return(Json(model, JsonRequestBehavior.AllowGet)); } if (model.PMS_No != null && model.MOP_No != null && model.SiteId != 0) { var obj = new M_MOP() { SiteId = model.SiteId, PMS_No = model.PMS_No, MOP_No = model.MOP_No, MOP_Desc = model.MOP_Desc, By_Whom = model.By_Whom, Periodicity = model.Periodicity, Period = model.Period, Doc = model.Doc, Task_Procedure = model.Task_Procedure, Safety_Precautions = model.Safety_Precautions, }; db.Entry(obj).State = EntityState.Modified; } db.SaveChanges(); transaction.Commit(); if (SiteId != null && eswbs != null) { vm = GetMopData(SiteId, eswbs); } _logger.Log(LogLevel.Trace, actionName + " :: ended."); return(Json(new { msg = "Data Updated Sucessfully!!!", model = vm.M_MOPModel_List, pmsNo = vm.pmsNo }, JsonRequestBehavior.AllowGet)); } catch (Exception ex) { _logger.Log(LogLevel.Error, actionName + " EXCEPTION :: " + ex.ToString() + " INNER EXCEPTION :: " + ex.InnerException?.ToString()); transaction.Rollback(); Exception(ex); Alert("Their is something went wrong!!!", NotificationType.error); return(Json(vm.M_MOPModel_List)); } } } }
public ActionResult DeleteConfirmed(int id) { Student student = db.Students.Find(id); var user = db.Users.Find(student.UserId); db.Users.Remove(user); db.Students.Remove(student); db.SaveChanges(); return(RedirectToAction("Index")); }
public ActionResult Create(tbl_Category category) { //view to controller, currently we're using args but later we'll see better way //controller to view, 3 ways ViewBag, ViewData, TempData //ViewBag.Name = name; //ViewBag.Desc = description; WebAppDbContext db = new WebAppDbContext(); db.tbl_Category.Add(category); db.SaveChanges(); return(View()); }
public ActionResult EditMOPItem(M_MOP_ItemsModel model, int?siteId, string pmsNo, string mopNo) { using (var db = new WebAppDbContext()) { using (var transaction = db.Database.BeginTransaction()) { MopViewModels vm = new MopViewModels(); try { if (!ModelState.IsValid) { Alert("Their is something went wrong!!!", NotificationType.error); return(Json(model, JsonRequestBehavior.AllowGet)); } if (model != null) { var obj = new M_MOP_ITEMS() { MOP_ItemsId = model.MOP_ItemsId, SiteId = Convert.ToInt32(model.SiteId), SR_Qty = model.SR_Qty, PMS_No = model.PMS_No, MOP_No = model.MOP_No, Part_No = model.Part_No, }; if (model.NewSelectedPart_No != null) { obj.Part_No = model.NewSelectedPart_No.Trim(); } db.Entry(obj).State = EntityState.Modified; } db.SaveChanges(); transaction.Commit(); if (siteId != null && pmsNo != null && mopNo != null) { vm = GetMopItemData(siteId, pmsNo, mopNo); } // Alert("Data Saved Sucessfully!!!", NotificationType.success); return(Json(new { msg = "Record Updated Sucessfully!!!", model = vm.M_MOP_ItemsModelList }, JsonRequestBehavior.AllowGet)); } catch (Exception ex) { transaction.Rollback(); Exception(ex); //Alert("Their is something went wrong!!!", NotificationType.error); return(Json(vm)); } } } }
public int Save() { try { return(context.SaveChanges()); } catch (Exception ex) { var message = GetType().CreateLogMessage(nameof(Save), ex.Message); logger.LogError(message); throw; } }
public void AddRating(int eventID, string giverId, string recieverId, int score, DateTime time) { if (GetAllRatings().ToList().Exists(r => r.GiverId == giverId && r.ReceiverId == recieverId && r.EventId == eventID)) { return; } else { MakeNewRating(eventID, giverId, recieverId, score, time); } dbContext.SaveChanges(); }
public ActionResult ReturnRequest(int?reqId, string remarks) { using (var db = new WebAppDbContext()) { try { if (reqId != null) { var result = db.tbl_Request.Where(x => x.RequestId == reqId).FirstOrDefault(); if (result != null) { result.Status = 3; db.Entry(result).Property(x => x.Status).IsModified = true; db.SaveChanges(); } tbl_RequestLog req = new tbl_RequestLog(); req.RequestId = reqId; req.Status = 3; req.Remarks = remarks; req.CurrentDateTime = DateTime.Now; req.UserId = System.Web.HttpContext.Current.User.Identity.GetUserId(); db.tbl_RequestLog.Add(req); db.SaveChanges(); } Alert("Request return Sucessfully!!!", NotificationType.success); return(RedirectToAction("Inbox")); } catch (Exception ex) { Exception(ex); Alert("Their is something went wrong!!!", NotificationType.error); return(RedirectToAction("Inbox")); } } }
public IActionResult Fruit(SampleViewModel vm) { if (!string.IsNullOrEmpty(vm.Name)) { if (vm.ModifyIdx == 0) { FruitModel fruit = new FruitModel(); fruit.name = vm.Name; db.Fruit.Add(fruit); db.SaveChanges(); } else { FruitModel fruit = db.Fruit.Find(vm.ModifyIdx); fruit.name = vm.Name; db.Fruit.Update(fruit); db.SaveChanges(); } } return(RedirectToAction("Fruit")); }
public long Insert(Credential entity) { int a = 0; string[] arrEmpId = string.Join(",", entity.SelectedIDRole).Replace(" ", "").Split(','); for (int i = 0; i < arrEmpId.Length; i++) { entity.RoleID = arrEmpId[i]; db.Credentials.Add(entity); db.SaveChanges(); a = 1; } return(a); }
public long Insert(Employee entity) { if (CheckUserName(entity.Username) == false && CheckCode(entity.Code) == false) { if (!string.IsNullOrEmpty(entity.Password)) { string password = entity.Password; // pass = pass + salt string salt = Crypto.GenerateSalt(); //Lưu lại giá trị hash và salt vào db entity.Password = salt; entity.Hash = Crypto.HashPassword(password + salt); } entity.Status = true; db.Employees.Add(entity); db.SaveChanges(); } return(entity.ID); }
public ActionResult Delete(int id, FormCollection collection) { string actionName = "Delete"; string msg = String.Empty; _logger.Log(LogLevel.Trace, actionName + " :: started."); try { if (id <= 0) { Alert("Invalid Cage Selected.", NotificationType.error); _logger.Log(LogLevel.Trace, actionName + " :: Ended. Invalid cage id : " + id); return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } else { using (var db = new WebAppDbContext()) { var result = db.tbl_Cage.FirstOrDefault(x => x.CageId == id); if (result != null) { result.Status = "InActive"; db.Entry(result).State = EntityState.Modified; db.SaveChanges(); msg = "Cage Deleted Successfully."; Alert(msg, NotificationType.success); } else { msg = "Cage Not Found."; Alert(msg, NotificationType.error); _logger.Log(LogLevel.Trace, actionName + " :: Ended. Cage id not found : " + id); } } } } catch (Exception ex) { Exception(ex); msg = "Something Went Wrong !!! "; Alert(msg, NotificationType.error); _logger.Log(LogLevel.Error, actionName + " EXCEPTION :: " + ex.ToString() + " INNER EXCEPTION :: " + ex.InnerException?.ToString()); } return(RedirectToAction("Index")); }
public int InsertStatisticTicketDate() { if (db.StatisticTickets.Count() != 0) { var all = from c in db.StatisticTickets select c; db.StatisticTickets.RemoveRange(all); db.SaveChanges(); } var list = db.OrderDetails.ToList(); foreach (var item in list) { DateTime a = item.DailyList.CreatedDate.Date; var s = db.StatisticTickets.Where(x => DbFunctions.TruncateTime(x.Datetime) == a && x.Ticket_ID == item.Ticket_ID).ToList(); if (s.Count == 0) { StatisticTicket sta = new StatisticTicket(); sta.Datetime = (DateTime)item.DailyList.CreatedDate; sta.TicketinDate = 1; sta.Employee_ID = "'" + item.Employee_ID + "'"; if (item.DailyList.Taxi == null) { sta.TicketPriceinDate = item.Amount; } else { sta.TicketPriceinDate = item.Amount + item.DailyList.Taxi.Price; } sta.Ticket_ID = (int)item.Ticket_ID; db.StatisticTickets.Add(sta); db.SaveChanges(); } else { var sta = db.StatisticTickets.Where(x => DbFunctions.TruncateTime(x.Datetime) == a && x.Ticket_ID == item.Ticket_ID).Select(x => x.ID).ToList(); foreach (var itemid in sta) { var statistic = db.StatisticTickets.Find(itemid); if (statistic.Employee_ID.Contains(item.ID.ToString()) != true) { statistic.TicketinDate = statistic.TicketinDate + 1; statistic.Employee_ID = statistic.Employee_ID + ",'" + item.Employee_ID + "'"; statistic.TicketPriceinDate = statistic.TicketPriceinDate + item.Amount; db.SaveChanges(); } } } } return(1); }
public ActionResult EditChildPart(ChildPartsModel model) { using (var db = new WebAppDbContext()) { using (var transaction = db.Database.BeginTransaction()) { PartsViewModels vm = new PartsViewModels(); try { if (!ModelState.IsValid) { Alert("Their is something went wrong!!!", NotificationType.error); return(Json(model, JsonRequestBehavior.AllowGet)); } if (model.ParentPartId != 0 && model.ChildPartId != 0) { var obj = new tbl_ChildParts() { ParentPartId = model.ParentPartId, ChildPartId = model.ChildPartId, Qty = model.Qty, }; db.Entry(obj).State = EntityState.Modified; } db.SaveChanges(); transaction.Commit(); int?parentPartId = model.ParentPartId; if (parentPartId != 0) { vm = GetData(parentPartId); } // Alert("Data Saved Sucessfully!!!", NotificationType.success); return(Json(vm.ChildPartsModel_list, JsonRequestBehavior.AllowGet)); } catch (Exception ex) { transaction.Rollback(); Exception(ex); Alert("Their is something went wrong!!!", NotificationType.error); return(Json(vm)); } } } }