public void CreateComplaint(int customerID, string description)
{
using (CinemaEntities database = new CinemaEntities())
{
Complaint newComplaint = database.Complaint.Create();
//obecna data
DateTime myDateTime = DateTime.Now;
//format daty poprawny do sql
string sqlFormattedDate = myDateTime.ToString("yyyy-MM-dd HH:mm");
newComplaint.Complaint_ID = Convert.ToInt32(database.sp_getSeqComplaintID().FirstOrDefault());
newComplaint.Customer_ID = customerID;
newComplaint.Description = description;
newComplaint.Date = DateTime.Parse(sqlFormattedDate);
database.Complaint.Add(newComplaint);
database.SaveChanges();
}
}
