public IHttpActionResult PutClientsTable(int id, ClientsTable clientsTable) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } if (id != clientsTable.ID) { return(BadRequest()); } db.Entry(clientsTable).State = EntityState.Modified; try { db.SaveChanges(); } catch (DbUpdateConcurrencyException) { if (!ClientsTableExists(id)) { return(NotFound()); } else { throw; } } return(StatusCode(HttpStatusCode.NoContent)); }
public int UpdateFertilizersOfPocket(List <PocketFertilizerMapping> pocketFertilizersMappingList) { List <PocketFertilizerMapping> ExistingList = GetFertilizerByPocket(pocketFertilizersMappingList.ElementAt(0).PocketId.Value).ToList(); List <PocketFertilizerMapping> CropsMappingToUpdate = pocketFertilizersMappingList.Select(x => x).Where(x => x.Id > 0).ToList(); List <PocketFertilizerMapping> CropsMappingToInsert = pocketFertilizersMappingList.Select(x => x).Where(x => x.Id == 0).ToList(); List <PocketFertilizerMapping> CropsMappingToDelete = ExistingList.Select(x => x).Where(x => !pocketFertilizersMappingList.Select(y => y.Id).Contains(x.Id)).ToList(); InsertFertilizersOfPocket(CropsMappingToInsert); DeleteFertilizerOfPocket(CropsMappingToDelete); PocketFertilizerMapping pocketFertilizerMapping = null; CropsMappingToUpdate.ForEach(y => { pocketFertilizerMapping = db.PocketFertilizerMappings.Select(x => x).Where(x => x.Id == y.Id).FirstOrDefault(); if (pocketFertilizerMapping != null) { pocketFertilizerMapping.FertilizerId = y.FertilizerId; pocketFertilizerMapping.PocketId = y.PocketId; } }); return(db.SaveChanges()); }
public int InsertPocket(PocketInfo pocketInfo) { pocketInfo.CreatedDate = DateTime.Now; pocketInfo.UpdatedDate = DateTime.Now; pocketInfo.CreatedBy = pocketInfo.CreatedBy; db.PocketInfoes.Add(pocketInfo); db.SaveChanges(); return(pocketInfo.PocketID); }
public ActionResult Create([Bind(Include = "ID,LastName,FirstName,Age,Gender")] ClientsTable clientsTable) { if (ModelState.IsValid) { db.ClientsTables.Add(clientsTable); db.SaveChanges(); return(RedirectToAction("Index")); } return(View(clientsTable)); }
public ActionResult Create([Bind(Include = "ID,Title,ReleaseDate,Genre,Price")] Movy movy) { if (ModelState.IsValid) { db.Movies.Add(movy); db.SaveChanges(); return(RedirectToAction("Index")); } return(View(movy)); }
public ActionResult Create([Bind(Include = "ID,deviceType,deviceModel,deviceGrade")] Device device) { if (ModelState.IsValid) { db.Devices.Add(device); db.SaveChanges(); return(RedirectToAction("Index")); } return(View(device)); }
public int DeletePocketVillageMappingListOfPocket(List <PocketVillageMapping> pocketVillageMappingList) { PocketVillageMapping pocketMapping = null; pocketVillageMappingList.ForEach(y => { pocketMapping = db.PocketVillageMappings.Select(x => x).Where(x => x.Id == y.Id).FirstOrDefault(); db.PocketVillageMappings.Remove(pocketMapping); }); return(db.SaveChanges()); }
public FAapproval InsertFAapproval(FAapproval faApproval) { try { db.FAapprovals.Add(faApproval); db.SaveChanges(); return(faApproval); } catch (Exception ex) { throw ex; } }
public IEnumerable <FAtargetVillageMapping> InsertFAtargetVillageMapping(IEnumerable <FAtargetVillageMapping> targetVillageMappingList) { try { db.FAtargetVillageMappings.AddRange(targetVillageMappingList); db.SaveChanges(); return(targetVillageMappingList); } catch (Exception ex) { throw ex; } }
public int InsertFAAddressDetail(FAaddressDetail faAddressDetail) { try { db.FAaddressDetails.Add(faAddressDetail); db.SaveChanges(); return(faAddressDetail.Id); } catch (Exception ex) { throw ex; } }
public int InsertFAdetail(FAdetail faDetail) { try { faDetail.FormNo = (faDetail.FirstName.Length > 3? faDetail.FirstName.Substring(0, 3):faDetail.FirstName.Substring(0, faDetail.FirstName.Length)) + faDetail.EnrollDate.Value.Day + faDetail.EnrollDate.Value.Month + faDetail.EnrollDate.Value.Year; db.FAdetails.Add(faDetail); db.SaveChanges(); return(faDetail.Id); } catch (Exception ex) { throw ex; } }
public IEnumerable <FAexperianceDetail> InsertFAexperienceDetail(IEnumerable <FAexperianceDetail> faExperienceDetailList) { try { foreach (var expDetail in faExperienceDetailList) { db.FAexperianceDetails.Add(expDetail); } db.SaveChanges(); return(faExperienceDetailList); } catch (Exception ex) { throw ex; } }
public IEnumerable <FAtargetDetail> InsertTargetsForFA(IEnumerable <FAtargetDetail> faTargetDetailList) { try { foreach (var targetDetail in faTargetDetailList) { db.FAtargetDetails.Add(targetDetail); } db.SaveChanges(); return(faTargetDetailList); } catch (Exception ex) { throw ex; } }
public ActionResult addEdit(Order orderData) { string message = ""; orderData.UserID = currentUserID; orderData.Date = DateTime.Today; db.Orders.Add(orderData); if (ModelState.IsValid) { db.SaveChanges(); return(RedirectToAction("Transaction", "OrderTransaction")); } else { message = "Invalid Request"; } return(RedirectToAction("Transaction")); }
public ActionResult ForgetPassword(string id) { //Verify Email ID //Generate Reset password link //Send Email string message = ""; bool status = false; var account = DB.Users.Where(a => a.Email == id).FirstOrDefault(); if (account != null) { //Send email for reset password Guid resetCode = Guid.NewGuid(); //RegisterHelperFunc.OldURL = Request.Url.PathAndQuery; /*LogInOut_ForgPass_Func HelperFunc = new LogInOut_ForgPass_Func(); * User returneUser = HelperFunc.UserExists(id); * returneUser.navigateToLink = false; * DB.Users.Attach(returneUser); * var entry = DB.Entry(returneUser); * entry.Property(e => e.navigateToLink).IsModified = true; * // other changed properties * DB.SaveChanges();*/ RegisterHelperFunc.sendverification(account.Email, resetCode.ToString(), "Forget_Password/ResetPassword"); account.ResetPasswordCode = resetCode; account.ResetPasswordDate = DateTime.Now; account.navigateToLink = false; //This line I have added here to avoid confirm password not match issue , as we had added a confirm password property //in our model class in part 1 DB.Configuration.ValidateOnSaveEnabled = false; DB.SaveChanges(); message = "Reset password link has been sent to your email id."; } else { message = "Account not found"; } ViewBag.Message = message; //return RedirectToAction("Login", "LoginAndLogout"); return(View()); }
public ActionResult Disblock(int id) { User user = db.Users.Where(x => x.ID == id).FirstOrDefault(); user.State = "Active"; var entry = db.Entry(user); entry.Property(e => e.State).IsModified = true; db.SaveChanges(); return(RedirectToAction("Index")); }
public IEnumerable <FAuploadedDocumentDetail> InsertUploadedDocumentDetailIst(IEnumerable <FAuploadedDocumentDetail> uplodedDocumentDetailList) { try { db.FAuploadedDocumentDetails.AddRange(uplodedDocumentDetailList); db.SaveChanges(); return(uplodedDocumentDetailList); } catch (Exception ex) { throw ex; } }
public ActionResult VerifyAccount(string id) { bool Status = false; using (DBentities db = new DBentities()) { db.Configuration.ValidateOnSaveEnabled = false;//to avoid confirm password does not match problem on save var v = db.Users.Where(a => a.ActivationCode == new Guid(id)).FirstOrDefault(); if (v != null) { v.IsEmailVerified = true; db.SaveChanges(); Status = true; } else { ViewBag.Message = "Invalid Request"; } } ViewBag.Status = Status; return(View()); }
public JsonResult SaveDataInDatabase(OrderTransactionModel orderData) { var result = false; //Check If User try to sell quantity more than you have it if (orderData.Type == false) { List <StockQuntity> query1 = (from ord in db.Orders where ord.UserID == currentUserID && ord.StockID == orderData.StockID && ord.Type == true group ord by new { ord.UserID, ord.StockID, ord.Type } into o select new StockQuntity { quantity = o.Sum(x => x.Quantity) }).Take(1).ToList(); int buy = 0; if (query1.Count > 0) { buy = query1[0].quantity; } List <StockQuntity> query2 = (from ord in db.Orders where ord.UserID == currentUserID && ord.StockID == orderData.StockID && ord.Type == false group ord by new { ord.UserID, ord.StockID, ord.Type } into o select new StockQuntity { quantity = o.Sum(x => x.Quantity) }).Take(1).ToList(); int sell = 0; if (query2.Count > 0) { sell = query2[0].quantity; } int selledBefore = 0; if (orderData.ID > 0) { selledBefore = db.Orders.Where(Z => Z.ID == orderData.ID).FirstOrDefault().Quantity; selledBefore = orderData.Quantity - selledBefore; } if ((buy - sell) < orderData.Quantity && orderData.ID <= 0) { return(Json(result, JsonRequestBehavior.AllowGet)); } else if (((buy - sell) < selledBefore) && orderData.ID > 0) { return(Json(result, JsonRequestBehavior.AllowGet)); } } try { if (orderData.ID > 0) { Order ord = db.Orders.SingleOrDefault(x => x.ID == orderData.ID); ord.Quantity = orderData.Quantity; db.SaveChanges(); result = true; } else { Order ord = new Order(); ord.UserID = currentUserID; ord.Date = DateTime.Today; ord.Quantity = orderData.Quantity; ord.StockID = orderData.StockID; ord.Type = orderData.Type; db.Orders.Add(ord); db.SaveChanges(); result = true; } } catch (Exception ex) { throw (ex); } return(Json(result, JsonRequestBehavior.AllowGet)); }
private int SaveChanges() { return(db.SaveChanges()); }
public int LogException(ProjectException exception) { db.ProjectExceptions.Add(exception); db.SaveChanges(); return(exception.Id); }
public ActionResult Login(loginModel model) { ViewBag.captchacount = 0.ToString(); if (model.Username == null || model.Password == null) { } else { Session["username"] = model.Username.ToString(); string hashedPassword = LogInOut_ForgPass_Func.GenerateSHA256String(model.Password); if (DB.Users.Where(x => x.UserName == model.Username).Where(x => x.State != "Active").FirstOrDefault() != null) { ViewBag.message = "User Blocked"; } else if (DB.Users.Where(x => x.UserName == model.Username).Where(x => x.IsEmailVerified == false).FirstOrDefault() != null) { ViewBag.message = "User not verified"; } else if (DB.Users.Where(x => x.UserName == model.Username).Where(x => x.Password == hashedPassword).FirstOrDefault() != null) { FormsAuthenticationTicket ticket = new FormsAuthenticationTicket( 1, // Ticket version model.Username, // Username to be associated with this ticket DateTime.Now, // Date/time ticket was issued DateTime.Now.AddDays(14), // Date and time the cookie will expire false, // if user has chcked rememebr me then create persistent cookie model.Username, FormsAuthentication.FormsCookiePath); string encrypted = FormsAuthentication.Encrypt(ticket); var cooki = new HttpCookie(FormsAuthentication.FormsCookieName, encrypted); cooki.Expires = DateTime.Now.AddDays(14); cooki.HttpOnly = true; Response.Cookies.Add(cooki); using (DBentities db = new DBentities()) { LogInOut_ForgPass_Func HelperFunc = new LogInOut_ForgPass_Func(); User resetCaptcha = HelperFunc.UsernameExists(model.Username); resetCaptcha.CaptchaCounter = 0; db.Users.Attach(resetCaptcha); var ourentry = db.Entry(resetCaptcha); ourentry.Property(e => e.CaptchaCounter).IsModified = true; db.SaveChanges(); } return(RedirectToAction("UserDashboard", "Dashboard")); } else { ViewBag.message = "Wrong password"; LogInOut_ForgPass_Func HelperFunc = new LogInOut_ForgPass_Func(); User LoginUser = HelperFunc.UsernameExists(model.Username); //User LoginUser = (from u in DB.Users // where u.Email == model.EmailID // select u).FirstOrDefault(); if (LoginUser != null) { LoginUser.CaptchaCounter++; ViewBag.captchacount = LoginUser.CaptchaCounter.ToString(); DB.Users.Attach(LoginUser); var entry = DB.Entry(LoginUser); entry.Property(e => e.CaptchaCounter).IsModified = true; // other changed properties DB.SaveChanges(); if (LoginUser.CaptchaCounter > 3) { return(RedirectToAction("Captcha")); } } else { ViewBag.message = "Wrong username or password"; } } } return(View()); }
public ActionResult Register([Bind(Exclude = "Admin,State,IsEmailVerified,ActivationCode")] User user) { bool Status = false; string message = ""; // //model validation if (ModelState.IsValid) { #region //email already exists //User exist = RegisterHelperFunc.UserExists(user.Email); User emailExist = DB.Users.Where(x => x.Email == user.Email).FirstOrDefault(); User usernameExist = RegisterHelperFunc.UsernameExists(user.UserName); if (emailExist != null && usernameExist != null) { ViewBag.validate = "Username and Email already exist"; return(View(user)); } else if (emailExist != null) { ViewBag.validate = "Email already exist"; ModelState.AddModelError("Email Exists", "Email already exists"); return(View(user)); } else if (usernameExist != null) { ViewBag.validate = "Username already exist"; return(View(user)); } #endregion #region Generate Activation code user.ActivationCode = Guid.NewGuid(); #endregion #region password hashing user.Password = LogInOut_ForgPass_Func.GenerateSHA256String(user.Password); //user.ConfirmPassword = Crypto.Hash(user.ConfirmPassword); #endregion #region answer hashing user.QuestionAnswer = LogInOut_ForgPass_Func.GenerateSHA256String(user.QuestionAnswer); #endregion user.IsEmailVerified = false; user.CaptchaCounter = 0; user.navigateToLink = false; #region save to database // using (DBentities db = new DBentities()) //{ // user.State = "active"; /// string ques = Request.Params[6].ToString(); // user.Question = (from q in db.Questions // where q.QTextEnglish == ques // select q).FirstOrDefault(); user.Admin = false; user.State = "Active"; DB.Users.Add(user); DB.SaveChanges(); //send email to user RegisterHelperFunc.OldURL = Request.Url.PathAndQuery; RegisterHelperFunc.sendverification(user.Email, user.ActivationCode.ToString()); message = "successfully registered. Account activation link has been sent to email: " + user.Email; Status = true; // } #endregion } else { message = "Invalid Request"; } //generate activation code //password hashing //save data to database ViewBag.Message = message; ViewBag.Status = Status; ViewBag.questions = DB.Questions.ToList(); return(View(user)); //return Content("ok"); }