public static Operation <CurrencyByDate> PostCurrencyByDate(CurrencyByDate currencyByDate) { ServiceClient client = new ServiceClient(); Dictionary <string, object> prms = new Dictionary <string, object>(); prms["currencyByDate"] = currencyByDate; Operation <CurrencyByDate> operation = client.Post <CurrencyByDate>("PostCurrencyByDate", prms); return(operation); }
private void btnOk_Click(object sender, EventArgs e) { currencyByDate = bindTool.DataObject; var postOperation = OperationHandler.PostCurrencyByDate(currencyByDate); if (postOperation.Successful) { this.Close(); } else { XtraMessageBox.Show(postOperation.Fail); } }
public Operation <CurrencyByDate> GetCurrencyLastValue(string Id) { Operation <CurrencyByDate> operation = new Operation <CurrencyByDate>(); if (Id == "1") { operation.Value = new CurrencyByDate { CurrencyId = 1, Id = 0, Date = DateTime.Now, Rate = 1 }; operation.Successful = true; return(operation); } try { CurrencyByDate currencyByDate = connection.Query <CurrencyByDate>("select TOP(1) * from CurrencyByDate Where CurrencyId = " + Id + " order by Date Desc").FirstOrDefault(); operation.Value = currencyByDate; operation.Successful = currencyByDate != null; } catch (Exception ex) { operation.Fail = ex.Message; } return(operation); }
public Operation <CurrencyByDate> PostCurrencyByDate(CurrencyByDate currencyByDate) { if (currencyByDate.Rate <= 0) { return(new Operation <CurrencyByDate>() { Fail = "Nisbət yanlış daxil edilmişdir" }); } if (currencyByDate.CurrencyId == 0) { return(new Operation <CurrencyByDate>() { Fail = "Məzənnə seçilməmişdir" }); } CurrencyByDate existingCurrencyBD = connection.Query <CurrencyByDate>("select * from CurrencyByDate where Date = @Date and CurrencyId = @CurrencyId", new { currencyByDate.Date, currencyByDate.CurrencyId }).FirstOrDefault(); if (existingCurrencyBD != null) { currencyByDate.Id = existingCurrencyBD.Id; // Cunki varsa merge edecek, merge etmek ucun de movcud olanin Id-si lazim } return(new DapperRepo().Post(currencyByDate)); }