public bool DeleteRate(RateModel model, string id)
{
try
{
ExecuteCommand(cn =>
{
MySqlCommand cmd = new MySqlCommand(@"update tblrate set deleted=1
where rtGUID=@id", cn);
cmd.Parameters.AddWithValue("id", id);
rst = cmd.ExecuteNonQuery();
});
if (rst == 1)
return true;
else
return false;
}
catch (Exception)
{
throw;
}
}
private void btn_inset_Rate_Click(object sender, EventArgs e)
{
string dateRate;
dateRate = cbo_date.Text;
RateModel RM;
try
{
if (layerRate.GetValRate(DateTime.Parse(cbo_date.Text), cbo_Curr_cd.SelectedValue.ToString()))
{
var exceptionMessage = "Rate Currency already exist";
// clsWin.ClearWindowsObJect(panelEx1);
clsWin.ErrorMessage((exceptionMessage).ToString(), "Oops");
cbo_date.Focus();
return;
}
RM = new RateModel()
{
rtGUID = Guid.NewGuid().ToString(),
rtDate = DateTime.Parse(cbo_date.Text),
CurrGUID = cbo_Curr_cd.SelectedValue.ToString(),
rtValue = double.Parse(txt_rate_value.Text.ToString()),
Comp = clsWin.GetComputerName(),
UserName = _frmMain.activeuser,
LastUpdate = DateTime.Now
};
layerRate.InSertRate(RM);
Btn_refresh.PerformClick();
}
catch (DbEntityValidationException ex)
{
var errorMessages = ex.EntityValidationErrors
.SelectMany(x => x.ValidationErrors)
.Select(x => x.ErrorMessage);
var exceptionMessage = string.Concat(errorMessages);
clsWin.ClearWindowsObJect(panelEx1);
clsWin.ErrorMessage((exceptionMessage).ToString(), "Oops");
Btn_refresh.PerformClick();
}
}
public bool UpdatetRate(RateModel model, string id)
{
try
{
ExecuteCommand(cn =>
{
MySqlCommand cmd = new MySqlCommand(@"update tblrate set rtDate=@rtDate,
CurrGUID=@CurrGUID,rtValue=@rtValue,Comp=@Comp,UserName=@username
where uGUID=@id", cn);
cmd.Parameters.AddWithValue("id", id);
cmd.Parameters.AddWithValue("@rtDate", model.rtDate);
cmd.Parameters.AddWithValue("@CurrGUID", model.CurrGUID);
cmd.Parameters.AddWithValue("@rtValue", model.rtValue);
cmd.Parameters.AddWithValue("@Comp", model.Comp);
cmd.Parameters.AddWithValue("@username", model.UserName);
rst = cmd.ExecuteNonQuery();
});
if (rst == 1)
return true;
else
return false;
}
catch (Exception)
{
throw;
}
}
public bool InSertRate(RateModel model)
{
try
{
ExecuteCommand(cn =>
{
MySqlCommand cmd = new MySqlCommand(@"Insert Into tblrate (rtGUID,rtDate,CurrGUID,rtValue,Comp,UserName,LastUpdate)
values(@rtGUID,@rtDate,@CurrGUID,@rtValue,@Comp,@username,@LastUpdate)", cn);
cmd.Parameters.AddWithValue("rtGUID", model.rtGUID);
cmd.Parameters.AddWithValue("@rtDate", model.rtDate);
cmd.Parameters.AddWithValue("@CurrGUID", model.CurrGUID);
cmd.Parameters.AddWithValue("@rtValue", model.rtValue);
cmd.Parameters.AddWithValue("@Comp", model.Comp);
cmd.Parameters.AddWithValue("@username", model.UserName);
cmd.Parameters.AddWithValue("@LastUpdate", model.LastUpdate);
rst = cmd.ExecuteNonQuery();
});
if (rst == 1)
return true;
else
return false;
}
catch (Exception)
{
throw;
}
}