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));
}
