private void LoadGrid()
{
using (HolaShalomDBEntities db = new HolaShalomDBEntities())
{
GridView1.DataSource = db.Upload_temp.ToList();
GridView1.DataBind();
}
}
private List <Hotel> LoadHotels()
{
if (hotels == null)
{
using (HolaShalomDBEntities db = new HolaShalomDBEntities())
{
var _hotels = from a in db.Hotels orderby a.name select a;
hotels = _hotels.ToList();
hotels.Insert(0, new Hotel()
{
ID = 0, name = "Select Hotel"
});
}
}
return(hotels.ToList());
}
public string ExtractDataTabletFromCSVFileToDb(string csv_file_path)
{
try
{
using (TextFieldParser csvReader = new TextFieldParser(csv_file_path))
{
csvReader.SetDelimiters(new string[] { ";" });
csvReader.HasFieldsEnclosedInQuotes = true;
using (HolaShalomDBEntities db = new HolaShalomDBEntities())
{
db.Database.ExecuteSqlCommand("DELETE FROM [Upload_temp]");
csvReader.ReadFields();
int count = 0;
while (!csvReader.EndOfData)
{
string[] fieldData = csvReader.ReadFields();
Upload_temp rowUpload = new Upload_temp();
rowUpload.PNR = fieldData[0];
rowUpload.names = fieldData[1];
rowUpload.phone = fieldData[2];
rowUpload.date_arr = Convert.ToDateTime(fieldData[3]);
rowUpload.num_arr = fieldData[4];
rowUpload.PAX = int.Parse(fieldData[5]);
rowUpload.date_dep = Convert.ToDateTime(fieldData[6]);
rowUpload.num_dep = fieldData[7];
rowUpload.hotel_name = fieldData[8];
rowUpload.comments = fieldData[9];
db.Upload_temp.Add(rowUpload);
count += db.SaveChanges();
}
if (count > 50)
{
throw new Exception("CSV file limited to 50 records");
}
}
}
return(string.Empty);
}
catch (Exception ex)
{
Exception rootEx = ex.GetBaseException();
string error = "There was a problem with the CSV file (internal error message: " + rootEx.Message + ")";
Logger.Write(error);
return(error);
}
}
private void LoadAgencies()
{
using (HolaShalomDBEntities db = new HolaShalomDBEntities())
{
ddlAgencies.DataSource = db.Agencies.ToList();
ddlAgencies.DataBind();
ListItem unknown = ddlAgencies.Items.FindByText("UNKNOWN");
ddlAgencies.Items.Remove(unknown);
ListItem hola = ddlAgencies.Items.FindByText("Hola Shalom");
ddlAgencies.Items.Remove(hola);
ListItem select = new ListItem()
{
Text = "Select Agency", Value = "0"
};
ddlAgencies.Items.Insert(0, select);
}
}
public Result updateTables(string fieldsStr, int rowIndex, string agency_fk, string hotel_fk)
{
Result result = new Result();
Client client_new = new Client();
try
{
using (HolaShalomDBEntities db = new HolaShalomDBEntities())
{
client_new = getClientObj(fieldsStr);
if ((client_new.num_dep != "" && client_new.date_dep == null) || (client_new.num_dep == "" && client_new.date_dep != null))
{
result.status = "danger";
result.message = "It is impossible have a flight number without a flight date or vice versa. Please correct the csv file and try again.";
return(result);
}
client_new.hotel_fk = int.Parse(hotel_fk);
client_new.agency_fk = int.Parse(agency_fk);
client_new.date_update = DateTime.Now;
db.Clients.Add(client_new);
// Create sale object
Sale sale_new = new Sale();
sale_new.PNR = client_new.PNR;
sale_new.agency_fk = client_new.agency_fk;
sale_new.date_sale = DateTime.Today;
sale_new.date_update = DateTime.Now;
sale_new.canceled = false;
sale_new.persons = client_new.PAX;
sale_new.sale_type = "External";
sale_new.product_fk = 1;
sale_new.remained_pay = 0;
db.Sales.Add(sale_new);
var activities = from a in db.Activities
join b in db.Rel_product_activity on a.ID equals b.activity_fk
where b.product_fk == sale_new.product_fk
select a;
foreach (var activity in activities)
{
SoldActivity saleEvent = new SoldActivity();
saleEvent.Sale = sale_new;
saleEvent.PNR = sale_new.PNR;
saleEvent.agency_fk = sale_new.agency_fk;
saleEvent.date_update = sale_new.date_update;
saleEvent.canceled = sale_new.canceled;
saleEvent.activity_fk = activity.ID;
saleEvent.event_fk = 0;
db.SoldActivities.Add(saleEvent);
}
db.SaveChanges();
result.status = "success";
result.message = String.Format("[Reservation <b>'[{0}] {1}'</b> was successfully inserted into the database.", client_new.PNR, client_new.names);
}
}
catch (DbUpdateException ex)
{
SqlException ex_sql = ex.GetBaseException() as SqlException;
if (ex_sql != null)
{
switch (ex_sql.Number)
{
case 547:
result.status = "warning";
result.message = ex_sql.Message; // "One of the flights does not exist in the system. Please enter the flights and try again.";
return(result);
case 2627:
result.status = "info";
result.message = String.Format("Reservation <b>[{0}] {1}</b> already exists in the system. No need to insert it again.", client_new.PNR, client_new.names);
return(result);
default:
result.status = "danger";
result.message = "SQL Exception: " + ex_sql.Message;
return(result);
}
}
else
{
result.status = "danger";
result.message = "SQL Exception: " + ex_sql.Message;
}
}
catch (Exception ex)
{
result.status = "danger";
result.message = "General Exception: " + ex.Message;
}
return(result);
}