protected void cmdOK_Click(object sender, EventArgs e)
{
try
{
int Service_ID = 3;
int Customer_ID = Convert.ToInt32(ViewState["id"]);
SalitaEntities db = new SalitaEntities();
DateTime from = Convert.ToDateTime(DateTime.Today.ToShortDateString() + " 12:00AM");
DateTime to = Convert.ToDateTime(DateTime.Today.ToShortDateString() + " 11:59PM");
if (db.CustomerNeeds.SingleOrDefault(p => p.Customer_ID == Customer_ID && p.RequestDateTime >= from && p.RequestDateTime <= to && p.RequestedService_ID == Service_ID && p.WasFullfilled == false) == null)
{
CustomerNeed S = new CustomerNeed();
S.Customer_ID = Customer_ID;
S.RequestDateTime = DateTime.Now;
S.WasFullfilled = false;
S.RequestedService_ID = Service_ID; // 3 == fuera del dealer
S.Address_Line = this.txtSendTo.Text;
S.Town = this.txtTown.Text;
S.ZipCode = this.txtZipCode.Text;
S.FromDealer = (this.cmbWhereTo.SelectedIndex == 0) ? true : false;
S.Canceled = false;
db.CustomerNeeds.Add(S);
db.SaveChanges();
if (this.cbRoundTrip.Checked)
{
S.WasFullfilled = false;
S.RequestedService_ID = 4; // 4 == transportacion al dealer
S.RequestDateTime = Convert.ToDateTime(DateTime.Today.ToShortDateString() + " " + this.cmbTime.SelectedValue);
S.FromDealer = !S.FromDealer;
db.CustomerNeeds.Add(S);
db.SaveChanges();
}
Response.Redirect("report_transportation.aspx");
}
else
{
throw new Exception("Ya existe un pedido de transportación para hoy el cliente con id: " + Customer_ID.ToString());
}
}
catch (Exception E)
{
this.CustomValidator1.IsValid = false;
this.CustomValidator1.ErrorMessage = E.Message;
}
}
public static void SetService(int Customer_ID, int Service_ID, string Note)
{
SalitaEntities db = new SalitaEntities();
var Need = new CustomerNeed();
Need.RequestDateTime = DateTime.Now;
Need.Customer_ID = Customer_ID;
Need.WasFullfilled = false;
Need.Note = Note;
Need.RequestedService_ID = Service_ID;
Need.Canceled = false;
db.CustomerNeeds.Add(Need);
db.SaveChanges();
}
protected void SetService(int Customer_ID, int Service_ID)
{
SalitaEntities db = new SalitaEntities();
var Need = new CustomerNeed();
Need.RequestDateTime = DateTime.Now;
Need.Customer_ID = Customer_ID;
Need.WasFullfilled = false;
Need.Note = this.txtServiceNote.Text;
Need.RequestedService_ID = Service_ID;
Need.Canceled = false;
db.CustomerNeeds.Add(Need);
db.SaveChanges();
}
public static void ProcessService(int Customer_ID, int Service_ID)
{
SalitaEntities db = new SalitaEntities();
if (db.CustomerNeeds.SingleOrDefault(p => p.Customer_ID == Customer_ID && p.RequestedService_ID == Service_ID && p.WasFullfilled == false) == null)
{
CustomerNeed S = new CustomerNeed();
S.Customer_ID = Customer_ID;
S.RequestDateTime = DateTime.Now;
S.WasFullfilled = false;
S.RequestedService_ID = Service_ID;
S.Canceled = false;
db.CustomerNeeds.Add(S);
db.SaveChanges();
}
}
protected void cmdSave_Click(object sender, EventArgs e)
{
try
{
int RecId = 0;
int.TryParse(Request.Form["myRecordId"].ToString(), out RecId);
string NoteField = this.txtNotes.Value;
// Not been saved
var FullName = this.txtEditFullName.Value;
var Phone = this.txtEditPhone.Value;
var VisitRecord = db.Visits.Single(p => p.Visit_ID == RecId);
VisitRecord.AG_Phone = Phone;
if (string.IsNullOrEmpty(this.cmbCompanions.Value))
{
VisitRecord.AG_Companions = 0;
}
else
{
VisitRecord.AG_Companions = Convert.ToInt32(this.cmbCompanions.Value);
}
VisitRecord.AG_Tag = this.txtTag.Value;
VisitRecord.AG_Advisor = this.txtAdvisor.Value;
VisitRecord.AG_LL = Convert.ToBoolean(this.cbLL.Checked);
VisitRecord.AG_RR = Convert.ToBoolean(this.lbR.Checked);
VisitRecord.AG_DriveTo = this.txtDriveTo.Value;
VisitRecord.AG_DriverName = this.txtDriver.Value;
VisitRecord.AG_AppointmentTime = this.txtAppointment.Value;
VisitRecord.AG_RegisteredTime = this.txtSignedInTime.Value;
VisitRecord.AG_AttendedTime = this.txtAtended.Value;
VisitRecord.AG_ArrivalTime = this.txtArriveTime.Value;
VisitRecord.AG_ExitTime = this.txtLeaveTime.Value;
VisitRecord.AG_Comments = NoteField;
//VisitRecord.AG_OK = this.cbOK.Checked; // Moved to click directly on ListView
int?Seat_X = 0;
int?Seat_Y = 0;
this.GetSeatCoords(1, ref Seat_X, ref Seat_Y);
VisitRecord.Seat_X = Seat_X;
VisitRecord.Seat_Y = Seat_Y;
this.db.SaveChanges();
//
// Update CustomersNeeds table to match
// the transportation information
//
bool Llevar = VisitRecord.AG_LL.Value;
bool Recojer = VisitRecord.AG_RR.Value;
DateTime todayLow = Convert.ToDateTime(DateTime.Today.ToShortDateString() + " 12:00AM");
DateTime todayHigh = Convert.ToDateTime(DateTime.Today.ToShortDateString() + " 11:59PM");
//
// Load my current transport requests
//
var myTransportRequests_LLevar = this.db.CustomerNeeds.SingleOrDefault(p => p.RequestedService_ID == 3 && p.Customer_ID == VisitRecord.Customer_ID && p.RequestDateTime >= todayLow && p.RequestDateTime <= todayHigh && p.WasFullfilled == false);
var myTransportRequests_Recojer = this.db.CustomerNeeds.SingleOrDefault(p => p.RequestedService_ID == 4 && p.Customer_ID == VisitRecord.Customer_ID && p.RequestDateTime >= todayLow && p.RequestDateTime <= todayHigh && p.WasFullfilled == false);
if (Llevar == false)
{
//
// If the llevar checkbox is false then delete my current open request if any
//
if (myTransportRequests_LLevar != null)
{
this.db.CustomerNeeds.Remove(myTransportRequests_LLevar);
this.db.SaveChanges();
}
}
else
{
if (myTransportRequests_LLevar != null)
{
myTransportRequests_LLevar.Address_Line = VisitRecord.AG_DriveTo;
myTransportRequests_LLevar.Note = NoteField;
}
else
{
//
// Create the transportation requests
//
CustomerNeed c = new CustomerNeed();
c.Customer_ID = VisitRecord.Customer_ID;
c.RequestedService_ID = 3; // Llevar
c.RequestDateTime = DateTime.Now;
c.WasFullfilled = false;
c.Note = NoteField;
c.Address_Line = VisitRecord.AG_DriveTo;
c.Town = "";
c.ZipCode = "";
c.FromDealer = true;
c.Canceled = false;
this.db.CustomerNeeds.Add(c);
}
this.db.SaveChanges();
}
if (Recojer == false)
{
if (myTransportRequests_Recojer != null)
{
this.db.CustomerNeeds.Remove(myTransportRequests_Recojer);
this.db.SaveChanges();
}
}
else
{
if (myTransportRequests_Recojer != null)
{
myTransportRequests_Recojer.Address_Line = VisitRecord.AG_DriveTo;
myTransportRequests_Recojer.Note = NoteField;
}
else
{
//
// Create the transportation requests
//
CustomerNeed c = new CustomerNeed();
c.Customer_ID = VisitRecord.Customer_ID;
c.RequestedService_ID = 4; // Recojer
c.RequestDateTime = DateTime.Now;
c.WasFullfilled = false;
c.Note = NoteField;
c.Address_Line = "Autogermana";
c.Town = "Guaynabo";
c.ZipCode = "";
c.FromDealer = false;
c.Canceled = false;
this.db.CustomerNeeds.Add(c);
}
this.db.SaveChanges();
}
this.LoadVisits();
}
catch (DbEntityValidationException dbex)
{
string validationErrors = "";
foreach (var eve in dbex.EntityValidationErrors)
{
validationErrors = string.Format("Entity of type \"{0}\" in state \"{1}\" has the following validation errors:",
eve.Entry.Entity.GetType().Name, eve.Entry.State);
foreach (var ve in eve.ValidationErrors)
{
validationErrors += string.Format("- Property: \"{0}\", Error: \"{1}\"",
ve.PropertyName, ve.ErrorMessage);
}
}
this.CustomValidator1.IsValid = false;
this.CustomValidator1.ErrorMessage = validationErrors;
}
catch (Exception ex)
{
this.CustomValidator1.IsValid = false;
this.CustomValidator1.ErrorMessage = ex.Message;
}
}
