//Add New Traveler To DataBase
protected void buttonAddNewTraveler_Click(object sender, EventArgs e)
{
//Declear message Variable
String msg = "";
try
{
//checked Duplicate Traveler
var DuplicateTraveler = TDC.TblTravelers.Where(x => x.TravelerNo.ToLower().Trim() == TextBoxTravelerNoAdd.Text.ToLower().Trim());
if (DuplicateTraveler.Count() > 0)
{
//show message
msg = " alert('Error! Duplicate Traveler Number not Allow ');";
ScriptManager.RegisterStartupScript(this, this.GetType(), "key", msg, true);
}
//Create New Traveler Obbject
var NewObj = new TblTraveler();
NewObj.TravelerNo = TextBoxTravelerNoAdd.Text.Trim();
NewObj.Priority = int.Parse(DropDownListPriorityAdd.SelectedValue);
NewObj.OrderDate = CalendarOrderDateAdd.SelectedDate;
NewObj.Status = int.Parse(DropDownListStatusAdd.SelectedValue);
NewObj.JobDescription = TextBoxDescriptionAdd.Text;
//Next Proccess Object
var TravelerProcessObj = new TblTravelerProcess();
TravelerProcessObj.ProcessAutoID = int.Parse(DropDownListNexProcessAdd.SelectedValue);
TravelerProcessObj.DateIn = DateTime.Now;
NewObj.TblTravelerProcesses.Add(TravelerProcessObj);
//add to database
TDC.TblTravelers.InsertOnSubmit(NewObj);
TDC.SubmitChanges();
//show message
msg = " alert('Save Traveler Successful');";
ScriptManager.RegisterStartupScript(this, this.GetType(), "key", msg, true);
//Refresh Traveler info Grid
LoadTravelerInfoGrid();
}
catch (Exception)
{
//show message
msg = " alert('Error To Save Traveler');";
ScriptManager.RegisterStartupScript(this, this.GetType(), "key", msg, true);
}
}
partial void DeleteTblTraveler(TblTraveler instance);
partial void UpdateTblTraveler(TblTraveler instance);
private void detach_TblTravelers(TblTraveler entity)
{
this.SendPropertyChanging();
entity.TblStatus = null;
}
partial void InsertTblTraveler(TblTraveler instance);
private void attach_TblTravelers(TblTraveler entity)
{
this.SendPropertyChanging();
entity.TblPriority = this;
}