public CargoVM GetCargo(int?Id)
{
try
{
Open();
var cargoVM = new CargoVM();
string selectEditCargo = @"SELECT* FROM CARGO WHERE IdCargo =" + Id;
SQL = new SqlCommand(selectEditCargo, sqlconnection);
Dr = SQL.ExecuteReader();
while (Dr.Read())
{
cargoVM.IdCargo = Convert.ToInt32(Dr["IdCargo"]);
cargoVM.dsCargo = Dr["dsCargo"].ToString();
cargoVM.flSituacao = Dr["flSituacao"].ToString();
cargoVM.dtCadastro = Convert.ToDateTime(Dr["dtCadastro"]);
cargoVM.dtUltAlteracao = Dr["dtUltAlteracao"] == DBNull.Value ? DateTime.Now : Convert.ToDateTime(Dr["dtUltAlteracao"]);
}
return(cargoVM);
}
catch (Exception e)
{
throw new Exception("Erro ao selecionar o Cargo: " + e.Message);
}
finally
{
Close();
}
}
private void DeliveryCargo(CargoVM arrivedCargo)
{
App.Current.Dispatcher.Invoke(() =>
{
Cargo.Remove(arrivedCargo);
Arrived.Add(arrivedCargo);
});
}
public ActionResult UpdateCargoName(CargoVM data)
{
Cargo cargo = new Cargo()
{
ID = data.ID,
CargoName = data.CargoName
};
service.CargoService.Update(cargo);
return(Json("OK", JsonRequestBehavior.AllowGet));
}
public ActionResult SendCargo(ProductInfo info, string lat, string lng, string OrderNote)
{
User user = (User)Session["LoginUser"];
ViewBag.User = user;
CargoVM cargoVM = new CargoVM();
cargoVM._ProductInfo = info;
cargoVM._ProductInfo.ProductDate = DateTime.Now;
cargoVM._Location = new Location()
{
Lat = lat,
Lng = lng,
LocationDate = DateTime.Now,
Description = OrderNote,
Address = "Şişli"
};
cargoVM._Order = new Order()
{
CustomerId = user.UserId,
OrderDate = DateTime.Now,
OrderNote = OrderNote
};
DataContractJsonSerializer ser =
new DataContractJsonSerializer(typeof(CargoVM));
MemoryStream mem = new MemoryStream();
ser.WriteObject(mem, cargoVM);
string data = Encoding.UTF8.GetString(mem.ToArray(), 0, (int)mem.Length);
WebClient webClientt = new WebClient();
webClientt.Headers["Content-type"] = "application/json";
webClientt.Encoding = Encoding.UTF8;
var response = webClientt.UploadString("http://localhost:65132/QarocoService.svc/SendCargo", "POST", data);
//CargoVM message = JsonConvert.DeserializeObject<CargoVM>(response);
if (response == "true")
{
TempData["Success"] = "Kargo gönderme işlemeniniz başarıyla gerçekleşmiştir.";
return(RedirectToAction("SendCargo"));
}
else
{
return(View());
}
}
public bool SendCargo(CargoVM model)
{
var _product = productRepository.Add(new ProductInfo
{
Height = model._ProductInfo.Height,
Price = model._ProductInfo.Price,
Size = model._ProductInfo.Size,
Weight = model._ProductInfo.Weight,
Width = model._ProductInfo.Width,
ProductDate = model._ProductInfo.ProductDate
});
var product = productRepository.GetByFilterx(p => p.ProductDate == model._ProductInfo.ProductDate || p.Weight == model._ProductInfo.Weight);
var _location = locationRepository.Add(new Location
{
Address = model._Location.Address, // address - Description - lat - lng - locationDate
Description = model._Location.Description,
Lat = model._Location.Lat,
Lng = model._Location.Lng,
LocationDate = model._Location.LocationDate
});
var location = locationRepository.GetByFilterx(l => l.LocationDate == model._Location.LocationDate || l.Address == model._Location.Address && l.Description == model._Location.Description);
var _order = orderRepository.Add(new Order
{
CustomerId = model._Order.CustomerId,
LocationId = location.LocationId,
OrderDate = model._Order.OrderDate,
OrderNote = model._Order.OrderNote,
//Birisi Aldığında true olur
OrderStatus = false,
ProductId = product.ProductId
});
if (_product && _location && _order)
{
return(true);
}
else
{
return(false);
}
}
public ActionResult UpdateInfo(CargoVM data)
{
var CargoVerileri = service.CargoService.Find(data.ID);
return(Json(CargoVerileri.CargoName, JsonRequestBehavior.AllowGet));
}
public bool CargoTransactionDelete(CargoVM model)
{
throw new NotImplementedException();
}
