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"));
}
}
