public static void UpdateCurrenciesService(provider providerName)
{
// ToDo: this list need to fill dynamically from config file
List <RateHistoryRequestBase> rateRequests = new List <RateHistoryRequestBase>()
{
RateHistoryRequestFactory.CreateRateHistory(currency.ILS, currency.USD, providerName),
RateHistoryRequestFactory.CreateRateHistory(currency.EUR, currency.USD, providerName),
RateHistoryRequestFactory.CreateRateHistory(currency.JPY, currency.EUR, providerName),
RateHistoryRequestFactory.CreateRateHistory(currency.EUR, currency.GBP, providerName)
};
Parallel.ForEach(rateRequests, async rateRequest =>
{
using (var cancellationTokenSource = new CancellationTokenSource())
{
IProgress <string> p = new Progress <string>(res =>
{
RateHistoryResponseBase responseBase = RateHistoryResponseFactory.DeserializeResponse(rateRequest.providerName, rateRequest.termRate, rateRequest.baseRate, res);
CurrencyBL.AddCurrency(responseBase.GetCurrencyName().ToString(), responseBase.GetCurrencyService(), responseBase.GetCurrencyValue());
});
await SingleHttpClientInstance.stringPostStreamAsync(rateRequest, cancellationTokenSource.Token, p);
}
});
}
/// <summary>
/// Inicializa componentes necessários para uso da classe.
/// </summary>
private void InitializeComponents()
{
mainWindowContext = (MainViewModel)Application.Current.MainWindow.DataContext; //Define contexto de dados da janela principal.
EFContext = mainWindowContext.EFContext;
UpdateWindowSizeAndPosition();
currentProvider = new provider();
SearchProvider();
#region Eventos
mainWindowContext.mainWindow.LocationChanged += WindowPositionHandler;
mainWindowContext.mainWindow.SizeChanged += WindowSizeHandler;
mainWindowContext.mainWindow.StateChanged += UpdateWindowSizeAndPosition;
#endregion
#region Comandos
searchProviderCommand = new RelayCommand(SearchProvider);
gridDoubleClickCommand = new RelayCommand(SetGridCurrentProvider);
resetCurrentProviderCommand = new RelayCommand(ResetProviderFields);
saveCurrentProviderCommand = new RelayCommand(InsertOrUpdateProvider);
deleteCurrentProviderCommand = new RelayCommand(RemoveProvider);
deleteGridProviderCommand = new RelayCommand(RemoveGridProvider);
newProviderCommand = new RelayCommand(NewProvider);
closeWindowCommand = new RelayCommand(CloseWindow);
minimizeWindowCommand = new RelayCommand(MinimizeWindow);
GetWebProviderCommand = new RelayCommand(GetProviderFromWeb);
#endregion
}
/// <summary>
/// Remove Fornecedor através da grid.
/// </summary>
private void RemoveGridProvider()
{
/// Seta os dados do fornecedor selecionado na grid.
UpdateProviderOnSelect();
//Verifica se o fornecedor atual existe no banco.
if (currentProvider.id != 0)
{
RefreshEFContext();
try
{
provider dBProvider = EFContext.providers.Find(currentProvider.id);
EFContext.providers.Remove(dBProvider);
EFContext.SaveChanges();
ResetProviderFields();
ButtonsHandler();
SearchProvider();
}
catch {
msgBox = new AlphaMessageBox(mainWindowContext.productWindow, "Não foi possivel excluir este fornecedor.");
msgBox.ShowDialog();
}
}
else
{
msgBox = new AlphaMessageBox(mainWindowContext.productWindow, "Selecione um fornecedor para excluir.");
msgBox.ShowDialog();
}
}
/// <summary>
/// 获取Excel客户端
/// </summary>
/// <returns>Excel客户端</returns>
public unsafe client GetClient()
{
provider provider = Enum <providerType, provider> .Array((byte)Provider);
pointer buffer = fastCSharp.sql.client.SqlBuffers.Get();
try
{
using (charStream connectionStream = new charStream(buffer.Char, fastCSharp.sql.client.SqlBufferSize))
{
connectionStream.SimpleWriteNotNull("Provider=");
connectionStream.Write(provider.Name);
connectionStream.SimpleWriteNotNull(";Data Source=");
connectionStream.Write(DataSource);
if (Password != null)
{
connectionStream.WriteNotNull(";Database Password="******";Extended Properties='");
connectionStream.Write(provider.Excel);
connectionStream.WriteNotNull(IsTitleColumn ? ";HDR=YES;IMEX=" : ";HDR=NO;IMEX=");
number.ToString((byte)Intermixed, connectionStream);
connectionStream.Write('\'');
return((client) new sql.connection {
Type = type.Excel, Connection = connectionStream.ToString()
}.Client);
}
}
finally { fastCSharp.sql.client.SqlBuffers.Push(ref buffer); }
}
// PUT: api/Customer/5
public HttpResponseMessage Put(int id, [FromBody] provider value)
{
try
{
using (QLMamNonEntities db = new QLMamNonEntities())
{
provider s = db.providers.SingleOrDefault(b => b.id == id);
if (s != null)
{
s.name = value.name;
s.phone = value.phone;
s.address = value.name;
db.SaveChanges();
return(Request.CreateResponse(HttpStatusCode.OK, new providerDTO(s.id, s.name, s.phone, s.address)));
}
else
{
return(null);
}
}
}
catch (Exception ex)
{
return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ex.Message));
}
}
public ActionResult Delete(int id)
{
provider p = gProvider.FindById(id);
gProvider.remove(p);
gProvider.Commit();
return(RedirectToAction("Index"));
}
public ActionResult DeleteConfirmed(int id)
{
provider provider = db.provider.Find(id);
db.provider.Remove(provider);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public ActionResult Edit([Bind(Include = "Id,Name,Phone,Mail,Adress")] provider provider)
{
if (ModelState.IsValid)
{
db.Entry(provider).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(provider));
}
public ActionResult Create([Bind(Include = "Id,Name,Phone,Mail,Adress")] provider provider)
{
if (ModelState.IsValid)
{
db.provider.Add(provider);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(provider));
}
public ActionResult Provider(provider p)
{
// int nid = Convert.ToInt32(TempData["new_user"].ToString());
nv.providers.Add(p);
nv.providers.Find(keyValues: p.user_id).user_id = Convert.ToInt32(TempData["new_user"].ToString());
nv.SaveChanges();
return(RedirectToAction("Index", "Provider"));
}
public Boolean DeleteProvider(out String Message, provider objProvider)
{
Message = String.Empty;
par = new Object[,]
{
{ "@ID", objProvider.providerId },
{ "@TxnType", TransactionType.DELETE }
};
return Delete(par, SP_Insert_Update_Delete, out Message);
}
/// <summary>
/// Atualiza dados do fornecedor do DB
/// </summary>
/// <param name="old">Fornecedor do contexto</param>
private void UpdateProvider(provider old)
{
old.adress = currentProvider.adress;
old.cnpj = currentProvider.cnpj;
old.email = currentProvider.email;
old.main_activity = currentProvider.main_activity;
old.name = currentProvider.name;
old.phone = currentProvider.phone;
old.active = currentProvider.active;
old.social_name = currentProvider.social_name;
}
public static RateHistoryResponseBase CreateRateResponse(provider currencyProvder)
{
if (currencyProvder == provider.Yahoo)
{
return(new YahooRateResponse());
}
else
{
return(null);
}
}
public ActionResult Create(provider prov)
{
if (ModelState.IsValid)
{
gProvider.Create(prov);
gProvider.Commit();
return(RedirectToAction("Index"));
}
else
{
return(View(prov));
}
}
public static RateHistoryResponseBase DeserializeResponse(provider currencyProvder, currency termCurrency, currency baseCurrency, string jsonResponse)
{
if (currencyProvder == provider.Yahoo)
{
YahooRateResponse YahooResponse = JsonConvert.DeserializeObject <YahooRateResponse>(jsonResponse);
YahooResponse.CurrencyName = $"{baseCurrency}/{termCurrency}";
return(YahooResponse);
}
else
{
return(null);
}
}
// GET: providers/Delete/5
public ActionResult Delete(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
provider provider = db.provider.Find(id);
if (provider == null)
{
return(HttpNotFound());
}
return(View(provider));
}
private void btnDanhMucXoa_Click(object sender, System.EventArgs e)
{
if (gvNhaCungCap.SelectedRowsCount != 1)
{
return;
}
provider pro = (provider)gvNhaCungCap.GetFocusedRow();
if (busNhaCungCap.Delete(pro))
{
XtraMessageBox.Show("Xóa thành công", this.Text, MessageBoxButtons.OK, MessageBoxIcon.Information, MessageBoxDefaultButton.Button1);
btnDanhMucLamMoi.PerformClick();
}
}
void gvNhaCungCap_FocusedRowChanged(object sender, DevExpress.XtraGrid.Views.Base.FocusedRowChangedEventArgs e)
{
if (gvNhaCungCap.SelectedRowsCount != 1)
{
return;
}
ncc = (provider)gvNhaCungCap.GetFocusedRow();
lblTenNhaCungCap.Text = ncc.name;
lblDiaChi.Text = ncc.address;
lblSoDienThoai.Text = ncc.phone;
lblEmail.Text = ncc.email;
dgvSanPhamCungCap.DataSource = busNhaCungCap.GetProduct(ncc);
}
// GET: api/Customer/5
public providerDTO Get(int id)
{
using (QLMamNonEntities db = new QLMamNonEntities())
{
provider s = db.providers.SingleOrDefault(x => x.id == id);
if (s != null)
{
return(new providerDTO(s.id, s.name, s.phone, s.address));
}
else
{
return(null);
}
}
}
// POST: api/Customer
public HttpResponseMessage Post([FromBody] provider obj)
{
try
{
using (QLMamNonEntities db = new QLMamNonEntities())
{
db.providers.Add(obj);
db.SaveChanges();
return(Request.CreateResponse(HttpStatusCode.Created, obj));
}
}
catch (Exception ex)
{
return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ex.Message));
}
}
public static async Task <IEnumerable <CurrencyBO> > GetCurrenciesAsync(provider provider)
{
Task t = Task.Factory.StartNew(() => CurrencyUpdater.UpdateCurrencies(provider));
t.Wait();
IEnumerable <CurrencyDO> Currencies = await CurrencyDAL.GetCurrenciesAsync(provider);
return(Currencies.Select(x => new CurrencyBO()
{
CurrencyLastUpdate = x.CurrencyLastUpdate,
CurrencyName = x.CurrencyName,
CurrencyService = x.CurrencyService,
CurrencyValue = x.CurrencyValue
}).ToList());
}
// DELETE: api/Customer/5
public HttpResponseMessage Delete(int id)
{
try
{
using (QLMamNonEntities db = new QLMamNonEntities())
{
provider s = db.providers.SingleOrDefault(x => x.id == id);
db.providers.Remove(s);
db.SaveChanges();
return(Request.CreateResponse(HttpStatusCode.OK));
}
}
catch (Exception ex)
{
return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ex.Message));
}
}
public static async Task <IEnumerable <CurrencyDO> > GetCurrenciesAsync(provider provider)
{
using (var context = new CurrencyEntities())
{
List <Currency> Currencies = await context.Currencies
.Where(x => x.CurrencyService == provider.ToString())
.ToListAsync();
return(Currencies.Select(x => new CurrencyDO()
{
CurrencyLastUpdate = x.CurrencyLastUpdate,
CurrencyName = x.CurrencyName,
CurrencyService = EnumUtility.ToEnum <provider>(x.CurrencyService),
CurrencyValue = x.CurrencyValue
}).ToList());
}
}
public ActionResult Update(int id, FormCollection collection)
{
if (ModelState.IsValid)
{
provider prov = gProvider.findProviderById(id);
prov.nom = collection["nom"];
prov.email = collection["email"];
prov.tel = collection["tel"];
prov.adresse = collection["adresse"];
gProvider.Update(prov);
gProvider.Commit();
return(RedirectToAction("Index"));
}
else
{
return(View());
}
}
/// <summary>
/// Insere dados coletados da grid no <see cref="currentProvider"/>
/// </summary>
private void UpdateProviderOnSelect()
{
if (currentProvider == null)
{
currentProvider = new provider();
}
if (gridCurrentProvider != null)
{
currentProvider.id = (int)gridCurrentProvider[0];
currentProvider.name = gridCurrentProvider[1].ToString();
currentProvider.social_name = gridCurrentProvider[2].ToString();
currentProvider.cnpj = gridCurrentProvider[3].ToString();
currentProvider.adress = gridCurrentProvider[4].ToString();
currentProvider.phone = gridCurrentProvider[5].ToString();
currentProvider.email = gridCurrentProvider[6].ToString();
currentProvider.main_activity = gridCurrentProvider[7].ToString();
currentProvider.active = (bool)gridCurrentProvider[8];
ButtonsHandler();
}
}
/// <summary>
/// Insere dados coletados da grid no <see cref="currentProvider"/>
/// </summary>
private void SetGridCurrentProvider()
{
if (currentProvider == null)
{
currentProvider = new provider();
}
if (gridCurrentProvider != null)
{
currentProvider.id = (int)gridCurrentProvider[0];
currentProvider.name = gridCurrentProvider[1].ToString();
currentProvider.social_name = gridCurrentProvider[2].ToString();
currentProvider.cnpj = gridCurrentProvider[3].ToString();
currentProvider.adress = gridCurrentProvider[4].ToString();
currentProvider.phone = gridCurrentProvider[5].ToString();
currentProvider.email = gridCurrentProvider[6].ToString();
currentProvider.main_activity = gridCurrentProvider[7].ToString();
currentProvider.active = (bool)gridCurrentProvider[8];
isQueryTabFocused = false;
isRegisterTabFocused = true;
ButtonsHandler();
}
}
private void btnLuu_Click(object sender, EventArgs e)
{
provider p = new provider();
p.id = txtMa.Text;
p.name = txtTen.Text;
p.phone = txtSdt.Text;
p.email = txtEmail.Text;
p.address = txtDiaChi.Text;
if (busNhaCungCap.Insert(p))
{
DialogResult = DialogResult.OK;
this.Close();
}
else
{
DialogResult = DialogResult.Cancel;
XtraMessageBox.Show("Có lỗi trong quá trình thêm, vui lòng kiểm tra lại", this.Text, MessageBoxButtons.OK, MessageBoxIcon.Error, MessageBoxDefaultButton.Button1);
this.Close();
}
}
public providerList GetProviderList()
{
provider objProvider = null;
providerList objProviderList = null;
myDataSet = ExecuteDataSet("SELECT * FROM tbl_Providers", null, CommandType.Text);
if (myDataSet.Tables.Count > 0 && myDataSet.Tables[0].Rows.Count > 0)
{
objProviderList = new providerList();
foreach (DataRow myDataRow in myDataSet.Tables[0].Rows)
{
objProvider =
new provider(
Int32.Parse(myDataRow["Provider_ID"].ToString())
, myDataRow["Provider_Name"].ToString()
, Int16.Parse(myDataRow["Provider_Order"].ToString())
, (Status)int.Parse(myDataRow["Provider_Status"].ToString()));
objProviderList.Add(objProvider);
}
}
return objProviderList;
}
public ActionResult CreateProvider(ProviderViewModel model)
{
try
{
using (AlmacenDBEntities db = new AlmacenDBEntities())
{
provider oProvider = new provider();
oProvider.name = model.name;
oProvider.phone = model.phone;
oProvider.rfc = model.rfc;
oProvider.id_location = model.location;
oProvider.address = model.address;
db.provider.Add(oProvider);
db.SaveChanges();
}
return(RedirectToAction("Index"));
}
catch
{
return(View());
}
}
private void btnLuu_Click(object sender, EventArgs e)
{
if (dpNgayLap.EditValue == null)
{
CheckLoi(lbNgayLap.Text);
dpNgayLap.Focus();
}
if (lkNhanVien.EditValue == null)
{
CheckLoi(lkNhanVien.Text);
lkNhanVien.Focus();
}
if (lkNhaCungCap.EditValue == null)
{
CheckLoi(lkNhaCungCap.Text);
lkNhaCungCap.Focus();
}
r = new receipt();
r.id = txtMaPhieuNhap.Text;
r.created = (DateTime)dpNgayLap.EditValue;
staff st = (staff)lkNhanVien.GetSelectedDataRow();
provider pr = (provider)lkNhaCungCap.GetSelectedDataRow();
r.staff = st;
r.provider = pr;
if (busNhapHang.Save())
{
XtraMessageBox.Show("Lưu thành công", this.Text, MessageBoxButtons.OK, MessageBoxIcon.Information, MessageBoxDefaultButton.Button1);
btnDanhMucLamMoi.PerformClick();
}
else
{
XtraMessageBox.Show("Lưu thất bại", this.Text, MessageBoxButtons.OK, MessageBoxIcon.Information, MessageBoxDefaultButton.Button1);
}
txtMaPhieuNhap.Text = null;
dpNgayLap.EditValue = lkNhaCungCap.EditValue = lkNhanVien.EditValue = null;
panelControl4.Enabled = false;
}
public List <OrdersViewModel> getOrdersViewModel()
{
var list = ordersList.Select(s => new { s.id, s.address, s.country, s.ordered, s.qteOfProduct, s.shipped, s.status, s.totalPrice, s.Admin, s.Stock, s.Provider }).ToList();
List <OrdersViewModel> orders = new List <OrdersViewModel>();
int pending = 0;
int recived = 0;
foreach (var s in list)
{
//Console.WriteLine(s.Admin1.firstName);
GestionUser gu = new GestionUser();
GestionStock gs = new GestionStock();
GestionProvider gp = new GestionProvider();
commande cm = new commande {
id = s.id, Admin = s.Admin, Stock = s.Stock, Provider = s.Provider, address = s.address, country = s.country, ordered = s.ordered, qteOfProduct = s.qteOfProduct, shipped = s.shipped, status = s.status, totalPrice = s.totalPrice
};
if (cm.status == 0)
{
pending++;
}
else
{
recived++;
}
user a = gu.FindById(cm.Admin.GetValueOrDefault());
stock st = gs.FindById(cm.Stock.GetValueOrDefault());
provider p = gp.FindById(cm.Provider.GetValueOrDefault());
orders.Add(new OrdersViewModel {
Cmd = cm, AdminName = a.FullName, ProviderName = p.nom, StockType = st.stockType
});
}
OrdersViewModel.pending = pending;
OrdersViewModel.recived = recived;
return(orders);
}
public Boolean SaveProvider(out String Message, providerList providerlist, provider objProvider)
{
Message = String.Empty;
//Check if duplicate records exists in the category list
if (providerlist.Select(element => element.providerName = objProvider.providerName).Count() > 1)
{
Message = CustomMessages.DUPLICATE("Provider", "Name");
return false;
}
else
{
par = new Object[,]
{
{ "@ID", objProvider.providerId }
, { "@Name", objProvider.providerName }
, { "@Order", objProvider.providerOrder }
, { "@Status", objProvider.providerStatus }
, { "@CreatedBy", HttpContext.Current.Session["UserID"] }
, { "@ModifiedBy", HttpContext.Current.Session["UserID"] }
, { "@TxnType", (objProvider.providerId>0 ? TransactionType.UPDATE: TransactionType.INSERT) }
};
return Save(par, SP_Insert_Update_Delete, out Message);
}
}
/// <summary>
/// Remove Fornecedor
/// </summary>
private void RemoveProvider()
{
//Verifica se o fornecedor atual existe no banco.
if (currentProvider.id != 0)
{
RefreshEFContext();
try
{
provider dBProvider = EFContext.providers.Find(currentProvider.id);
EFContext.providers.Remove(dBProvider);
EFContext.SaveChanges();
ResetProviderFields();
ButtonsHandler();
SearchProvider();
isRegisterTabFocused = false;
isQueryTabFocused = true;
}
catch
{
msgBox = new AlphaMessageBox(mainWindowContext.productWindow, "Náo foi possivel excluir este fornecedor.");
msgBox.ShowDialog();
}
}
}
