async void LoadViewModel()
{
Task <ExchangeRateVM> task = ExchangeRateVM.Create();
ViewModel = await task;
rootFrame.Navigate(typeof(MainPage), ViewModel); // как только загрузка прошла переходим на MainPage
Window.Current.Content = rootFrame;
}
public ExchangeRateVM SaveExchange(ExchangeRateVM Exchange)
{
try
{
if (!Exchange.EditFlag)
{
ds = _EzBusinessHelper.ExecuteDataSet("Select count(*) as [count1] from MEXR017 where CmpyCode='" + Exchange.CmpyCode + "' and CurCode='" + Exchange.CurCode + "'");
dt = ds.Tables[0];
int Exchange1 = 0;
foreach (DataRow dr in dt.Rows)
{
Exchange1 = int.Parse(dr["count1"].ToString());
}
if (Exchange1 == 0)
{
StringBuilder sb = new StringBuilder();
sb.Append("'" + Exchange.CmpyCode + "',");
sb.Append("'" + Exchange.CurCode + "',");
sb.Append("'" + Exchange.CurName + "',");
sb.Append("'" + Exchange.CurRate + "')");
_EzBusinessHelper.ExecuteNonQuery("insert into MEXR017(CmpyCode,CurCode,CurName,CurRate) values(" + sb.ToString() + "");
Exchange.SaveFlag = true;
Exchange.ErrorMessage = string.Empty;
}
else
{
Exchange.SaveFlag = false;
Exchange.ErrorMessage = "Duplicate Record";
}
return(Exchange);
}
var ExchangeEdit = _EzBusinessHelper.ExecuteNonQuery("Select * from MEXR017 where CmpyCode='" + Exchange.CmpyCode + "' and CurCode='" + Exchange.CurCode + "'");
if (ExchangeEdit != 0)
{
_EzBusinessHelper.ExecuteNonQuery("update MEXR017 set CmpyCode='" + Exchange.CmpyCode + "',CurCode='" + Exchange.CurCode + "',CurName='" + Exchange.CurName + "',CurRate='" + Exchange.CurRate + "' where CmpyCode='" + Exchange.CmpyCode + "' and CurCode='" + Exchange.CurCode + "'");
Exchange.SaveFlag = true;
Exchange.ErrorMessage = string.Empty;
}
else
{
Exchange.SaveFlag = false;
Exchange.ErrorMessage = "Record not available";
}
}
catch
{
Exchange.SaveFlag = false;
// unit.ErrorMessage = exceptionMessage;
}
return(Exchange);
}
public ExchangeRateVM SaveExchange(ExchangeRateVM Exchange)
{
return(_finaceRepo.SaveExchange(Exchange));
}
