private void loadCourierCombo()
{
try
{
conDB = new ConnectionDB();
CourierModel courier = new CourierModel();
string queryString = "SELECT ID, couriername, description FROM dbfh.tblcourier WHERE isDeleted = 0";
MySqlDataReader reader = conDB.getSelectConnection(queryString, null);
cmbCourier.Items.Clear();
while (reader.Read())
{
courier.ID = reader["ID"].ToString();
courier.CourierName = reader["couriername"].ToString();
courier.Description = reader["description"].ToString();
cmbCourier.Items.Add(courier);
courier = new CourierModel();
}
conDB.closeConnection();
}
catch (Exception ex)
{
conDB.writeLogFile("LOAD COURIER COMBO NO PARAM" + "-" + ex.Message.ToString());
}
}
private void loadCourierCombo(DirectSalesModel directSales)
{
conDB = new ConnectionDB();
CourierModel courier = new CourierModel();
string queryString = "SELECT ID, couriername, description FROM dbfh.tblcourier WHERE isDeleted = 0";
MySqlDataReader reader = conDB.getSelectConnection(queryString, null);
cmbCourier.Items.Clear();
while (reader.Read())
{
courier.ID = reader["ID"].ToString();
courier.CourierName = reader["couriername"].ToString();
courier.Description = reader["description"].ToString();
cmbCourier.Items.Add(courier);
if (directSales.CourierID.Equals(courier.ID))
{
cmbCourier.SelectedItem = courier;
}
courier = new CourierModel();
}
conDB.closeConnection();
}
private void loadCourierCombo(DirectSalesModel directSales)
{
try
{
conDB = new ConnectionDB();
CourierModel courier = new CourierModel();
string queryString = "SELECT ID, couriername, description FROM dbfh.tblcourier WHERE isDeleted = 0";
MySqlDataReader reader = conDB.getSelectConnection(queryString, null);
cmbCourier.Items.Clear();
while (reader.Read())
{
courier.ID = reader["ID"].ToString();
courier.CourierName = reader["couriername"].ToString();
courier.Description = reader["description"].ToString();
cmbCourier.Items.Add(courier);
if (directSales.CourierID.Equals(courier.ID))
{
cmbCourier.SelectedItem = courier;
}
courier = new CourierModel();
}
conDB.closeConnection();
}
catch (Exception ex)
{
conDB.writeLogFile("LOAD COURIER ON COMBO" + "-" + ex.Message.ToString() + "||" + ex.StackTrace);
}
}
public List <CourierModel> GetCouriers()
{
var couriers = new List <CourierModel>();
const string query = "Select * from couriers;";
using (MySqlConnection conn = new MySqlConnection(WebApiConfig.ConnectionString))
using (MySqlCommand command = new MySqlCommand(query, conn))
{
conn.Open();
using (var reader = command.ExecuteReader())
{
while (reader.HasRows)
{
while (reader.Read())
{
var courier = new CourierModel
{
Id = reader.GetInt32(0),
Courier = reader.GetString(1),
URL = reader.GetString(2),
};
couriers.Add(courier);
}
reader.NextResult();
}
}
}
return(couriers);
}
public async Task <IEnumerable <CourierModel> > GetAllCouriers()
{
try
{
List <CourierModel> CourierList = new List <CourierModel>();
var listOfUsers = await context.Users.ToListAsync();
var listOfUserRoles = context.UserRoles.Where(ur => ur.RoleID == 4).ToList();
foreach (var item in listOfUserRoles)
{
var usr = listOfUsers.Where(u => u.UserID == item.UserID).FirstOrDefault();
if (usr != null)
{
CourierModel c = new CourierModel()
{
CourierFullName = usr.FirstName + " " + usr.LastName,
CourierID = usr.UserID
};
CourierList.Add(c);
}
}
return(CourierList);
}
catch { return(null); }
}
public void UpdateCourier(CourierModel c)
{
Courier c1 = db.Courier.Where(i => i.Id == c.Id).FirstOrDefault();
db.Entry(toCourier(c1, c)).State = EntityState.Modified;
db.SaveChanges();
}
private async void DeliveryButton_Clicked(object sender, EventArgs e)
{
CourierModel courier = CourierPicker.SelectedItem as CourierModel;
if (DeliveryButton.Text.ToLower() == "završi" && PotencialDelivery != null)
{
if (await CheckDelivery(PotencialDelivery))
{
try
{
PotencialDelivery.PaymentTypeID = PaymentTypePicker.SelectedIndex + 1;
PotencialDelivery.DeliveryTypeID = DeliverTypePicker.SelectedIndex + 1;
PotencialDelivery.CourierID = courier.CourierID;
PotencialDelivery.StartAddress.Zone = Convert.ToInt32(ZoneStart.Value);
PotencialDelivery.EndAddress.Zone = Convert.ToInt32(ZoneEnd.Value);
PotencialDelivery.CreateTime = DateTime.Now;
if (await StartAddressCheck())
{
await DisplayAlert("Greska", "", "Potvrdi");
}
if (await EndAddressCheck())
{
await DisplayAlert("Greska", "", "Potvrdi");
}
DeliveryModel dtodel = PotencialDelivery;
dtodel.StartAddress = null;
dtodel.EndAddress = null;
var PostDelivery = await deliveryService.CreateDelivery(dtodel);
if (PostDelivery != null)
{
await DisplayAlert("BaraBara", "Dostava je poslata kuriru", "Potvrdi.");
await Navigation.PopToRootAsync();
}
else
{
await DisplayAlert("Došlo je do greške.", "Pokušaj ponovo.", "Potvrdi");
}
}
catch (Exception ex)
{
await DisplayAlert("Došlo je do greške.", "Pokušaj ponovo. " + Environment.NewLine + "Tekst greške : " + ex.Message, "Potvrdi");
}
}
else
{
await DisplayAlert("Došlo je do greške.", "Pokušaj ponovo.", "Potvrdi");
}
}
else
{
await DisplayAlert("Došlo je do greške.", "Pokušaj ponovo.", "Potvrdi");
}
}
public Courier toCourier(Courier c, CourierModel c1)
{
c.Id = c1.Id;
c.LastName = c1.LastName;
c.MiddleName = c1.MiddleName;
c.FirstName = c1.FirstName;
c.Phone = c1.Phone;
c.Login = c1.Login;
c.Password = c1.Password;
return(c);
}
private void updateDirectSalesRecord(DirectSalesModel directSalesModel)
{
conDB = new ConnectionDB();
BankModel bb = cmbCashBank.SelectedItem as BankModel;
CourierModel cc = cmbCourier.SelectedItem as CourierModel;
string queryString = "UPDATE dbfh.tbldirectsales SET deliverydate = ?, clientname = ?, cashbankID = ?, " +
"courierID = ?, expenses = ?, totalprice = ?, officeID = ?, remarks = ?, isPaid = ? WHERE ID = ?";
List <string> parameters = new List <string>();
DateTime date = DateTime.Parse(deliveryDateDS.Text);
parameters.Add(date.Year + "/" + date.Month + "/" + date.Day);
parameters.Add(txtClientName.Text);
parameters.Add(bb.ID);
parameters.Add(cc.ID);
parameters.Add(txtExpenses.Text);
parameters.Add(txtTotalPrice.Text);
parameters.Add(cmbSalesOffice.SelectedValue.ToString());
parameters.Add(txtRemarks.Text);
if (chkPaid.IsChecked.Value)
{
parameters.Add("1");
}
else
{
parameters.Add("0");
}
parameters.Add(directSalesModel.ID);
conDB.AddRecordToDatabase(queryString, parameters);
conDB.closeConnection();
}
private async Task <bool> GetDeliveriesFromServer()
{
CourierModel cmNull = new CourierModel {
CourierFullName = "???"
};
var list = await deliveryService.GetDeliveriesForDispatcher();
if (list != null)
{
listOfDeliveries = new List <ExtendedDeliveryModel>(list);
#region sqlLite
//await _connection.DropTableAsync<DeliveryModel>();
// await _connection.CreateTableAsync<DeliveryModel>();
//int x = await _connection.UpdateAsync(item);
//if (x == 0)
//{
// await _connection.InsertAsync(item);
//}
#endregion
if (listOfCouriers != null)
{
foreach (var item in listOfDeliveries)
{
var cm = listOfCouriers.Where(u => u.CourierID == item.CourierID).FirstOrDefault();
if (cm != null)
{
item.Courier = cm;
}
else
{
item.Courier = cmNull;
}
//Delivery detail image
switch (item.DeliveryStatus)
{
case 4:
item.DeliveryStatusImageSource = "delivered.png";
break;
case 3:
item.DeliveryStatusImageSource = "zeleni50.png";
break;
case 2:
item.DeliveryStatusImageSource = "zuti50.png";
break;
case 1:
item.DeliveryStatusImageSource = "crveni50.png";
break;
default:
item.DeliveryStatusImageSource = "crveni50.png";
break;
}
}
}
DeliveryList.ItemsSource = listOfDeliveries;
return(true);
}
else
{
Message.Text = "No deliveries to show.";
Message.IsVisible = true;
Message.IsEnabled = true;
return(false);
}
}
private async void DeliveryButton_Clicked(object sender, EventArgs e)
{
CourierModel courier = CourierPicker.SelectedItem as CourierModel;
if (delivery != null)
{
if (await CheckDelivery(delivery))
{
//switch (delivery.DeliveryStatus)
//{
// case 0:
// delivery.DeliveryStatus = 1;
// break;
// case 1:
// delivery.DeliveryStatus = 1;
// break;
// case 2:
// delivery.DeliveryStatus = 2;
// break;
// case 3:
// delivery.DeliveryStatus = 3;
// break;
// case 4:
// delivery.DeliveryStatus = 4;
// break;
//}
delivery.PaymentTypeID = PaymentTypePicker.SelectedIndex + 1;
delivery.DeliveryTypeID = DeliverTypePicker.SelectedIndex + 1;
delivery.CourierID = courier.CourierID;
delivery.StartAddress.Zone = Convert.ToInt32(ZoneStart.Value);
delivery.EndAddress.Zone = Convert.ToInt32(ZoneEnd.Value);
if (!await StartAddressCheck())
{
await DisplayAlert("Greska", "", "Potvrdi");
}
///Nova End Addressa
// var postEndAddress = await addressService.PostFullAddress(startAddress);
//PotencialDelivery.EndAddressID = await TypeHelp(postEndAddress);
if (!await EndAddressCheck())
{
await DisplayAlert("Greska", "", "Potvrdi");
}
//if (!checkStartAddress(startAddress))
// {
// // delivery.StartAddressID = delivery.StartAddressID;
// object sAddress = await addressService.PostFullAddress(startAddress);
// delivery.StartAddressID = await TypeHelp(sAddress);
//}
// if (!checkEndAddress(endAddress))
// {
// // newDelivery.EndAddressID = delivery.EndAddressID;
// object eAddress = await addressService.PostFullAddress(endAddress);
// delivery.EndAddressID = await TypeHelp(eAddress);
//}
try
{
var PostDelivery = await deliveryService.EditDelivery(delivery as DeliveryModel);
if (PostDelivery != null)
{
await DisplayAlert("BaraBara", "Dostava je ažurirana.", "Potvrdi.");
await Navigation.PopToRootAsync();
}
else
{
await DisplayAlert("Došlo je do greške.", "Pokušaj ponovo.", "Potvrdi");
}
}
catch (Exception ex)
{
await DisplayAlert("Došlo je do greške.", "Pokušaj ponovo. " + Environment.NewLine + "Tekst greške : " + ex.Message, "Potvrdi");
}
}
}
}
private async Task <bool> GetDeliveriesFromServer(DateTime OD, DateTime DO)
{
CourierModel cmNull = new CourierModel {
CourierFullName = "???"
};
////erro casting list of objects
///
var list = await deliveryService.GetDeliveriesByDate(OD, DO);
if (list != null)
{
listOfDeliveries = new List <ExtendedDeliveryModel>();
foreach (var item in list)
{
switch (item.DeliveryStatus)
{
case 4:
item.DeliveryStatusImageSource = "delivered.png";
break;
case 3:
item.DeliveryStatusImageSource = "zeleni50.png";
break;
case 2:
item.DeliveryStatusImageSource = "zuti50.png";
break;
case 1:
item.DeliveryStatusImageSource = "crveni50.png";
break;
default:
item.DeliveryStatusImageSource = "crveni50.png";
break;
}
ExtendedDeliveryModel extD = new ExtendedDeliveryModel();
extD = item.ConvertToExtended();
if (listOfCouriers != null)
{
var cm = listOfCouriers.Where(u => u.CourierID == item.CourierID).FirstOrDefault();
if (cm != null)
{
extD.Courier = cm;
}
else
{
extD.Courier = cmNull;
}
}
//Delivery detail image
listOfDeliveries.Add(extD);
}
DeliveryList.ItemsSource = listOfDeliveries;
DeliveryListOrderBy();
return(true);
}
else
{
Message.Text = "No deliveries to show.";
Message.IsVisible = true;
Message.IsEnabled = true;
return(false);
}
}
public void DeleteCourier(CourierModel s)
{
db.Courier.Remove(db.Courier.Find(s.Id));
}
public void addCourier(CourierModel z)
{
db.Courier.Add(toCourier(new Courier(), z));
}
