public static bool EditStudent(StudentDTO student) { using (Gymnastics_Studio_DataEntities context = new Gymnastics_Studio_DataEntities()) { var s = context.Students.FirstOrDefault(x => x.Id == student.Id); if (s != null) { s.FirstName = student.FirstName?.TrimStart().TrimEnd(); s.LastName = student.LastName?.TrimStart().TrimEnd(); s.IdentityNumber = student.IdentityNumber?.TrimStart().TrimEnd(); s.PhoneNumber = student.PhoneNumber?.TrimStart().TrimEnd(); s.Pignicher = student.Pignicher?.TrimStart().TrimEnd(); s.Comments = student.Comments?.TrimStart().TrimEnd(); if (s.CreditDetail == null) { CreditDetail creditDetail = new CreditDetail(); creditDetail.Students.Add(s); } s.CreditDetail.CreditNumber = student.CreditCardNumber; s.HMO = student.HMO?.TrimStart().TrimEnd(); s.Addrees = student.Addrees?.TrimStart().TrimEnd(); s.BirthDay = student?.BirthDay; s.StartDate = student?.StartDate.TrimStart().TrimEnd(); context.SaveChanges(); return(true); } else { return(false); } } }
public static dtoCreditDetail castToDto(CreditDetail objToCast) { return(new dtoCreditDetail() { CreditDetailsId = objToCast.CreditDetailsId, PaymentId = objToCast.PaymentId, PayerName = objToCast.PayerName, OwnerName = objToCast.OwnerName, OwnerIdentityNumber = objToCast.OwnerIdentityNumber, CreditNumber = objToCast.CreditNumber, CardExpirationDate = objToCast.CardExpirationDate, ThreeLastDigits = objToCast.ThreeLastDigits, NumberOfPayments = objToCast.NumberOfPayments, FirstRepaymentDate = objToCast.FirstRepaymentDate, Comments = objToCast.Comments }); }
public IActionResult InsertCredit(CreditDetail creditDetail) { if (ModelState.IsValid) { UserInfo userInfo = getUserInfo(HttpContext.Session.GetString("memberID")); // get available credit amount from database int availableCredits = Convert.ToInt32(userInfo.availableCredits); // get credit amount from razor view int creditAmount = Convert.ToInt32(creditDetail.creditAmount); if (availableCredits >= creditAmount) { if (availableCredits - creditAmount >= 0) { string connectionString = Configuration["ConnectionStrings:DefaultConnection"]; using (SqlConnection connection = new SqlConnection(connectionString)) { string sql = $"INSERT INTO [transaction] (memberID, creditAmount, transactionDate) VALUES ('{userInfo.memberID}', {creditAmount},'{DateTime.Now.ToString("yyyy-MM-dd")}')"; using (SqlCommand command = new SqlCommand(sql, connection)) { command.CommandType = CommandType.Text; connection.Open(); command.ExecuteNonQuery(); connection.Close(); } sql = $"UPDATE [user] SET availableCredits={ availableCredits - creditAmount } WHERE memberID='{ HttpContext.Session.GetString("memberID") }'"; using (SqlCommand command = new SqlCommand(sql, connection)) { command.CommandType = CommandType.Text; connection.Open(); command.ExecuteNonQuery(); connection.Close(); } } // clear the Session HttpContext.Session.Clear(); // redirect to main menu page return(RedirectToAction("Index", "MainMenu")); } else { // set error message to Session HttpContext.Session.SetString("error", "You don't have enough credit amount"); return(RedirectToAction("Index", "UseCredit")); } } else { // set error message to Session HttpContext.Session.SetString("error", "You don't have enough credit amount"); return(RedirectToAction("Index", "UseCredit")); } } else { // set error message to Session HttpContext.Session.SetString("error", "You don't have enough credit amount"); return(RedirectToAction("Index", "UseCredit")); } }