public frmFXandSP()
{
InitializeComponent();
fxspbal = new FXSPBAL();
fxsp = new tbl_000_FXSP();
err = new ErrorProviderExtended();
}
public frmCompanyProfile()
{
InitializeComponent();
yearbal = new YearBAL();
year = new tbl_YEAR();
fxsp = new tbl_000_FXSP();
compbal = new CompanyBAL();
comp = new tbl_000_COMPANY();
err = new ErrorProviderExtended();
}
public Boolean Save(tbl_000_FXSP record)
{
using (var dbContextTransaction = db.Database.BeginTransaction())
{
try
{
db.FXSPList.Add(record);
db.SaveChanges();
dbContextTransaction.Commit();
return(true);
}
catch (Exception ex)
{
dbContextTransaction.Rollback();
throw ex;
}
}
}
public void DeleteRecord()
{
var fxsptype = "";
var fxspeffdate = "";
try
{
if (mgridList1.SelectedRows != null)
{
fxsptype = mgridList1.Rows[mgridList1.SelectedCells[0].RowIndex].Cells["colRecType1"].Value.ToString();
fxspeffdate = mgridList1.Rows[mgridList1.SelectedCells[0].RowIndex].Cells["colEffectiveDate1"].Value.ToString();
}
}
catch
{
if (mgridList2.SelectedRows != null)
{
fxsptype = mgridList2.Rows[mgridList2.SelectedCells[0].RowIndex].Cells["colRecType2"].Value.ToString();
fxspeffdate = mgridList2.Rows[mgridList2.SelectedCells[0].RowIndex].Cells["colEffectiveDate2"].Value.ToString();
}
}
string rectype = fxsptype;
string effectivedate = fxspeffdate;
if (MessageHelpers.ShowQuestion("Are you sure you want to delete record?") == System.Windows.Forms.DialogResult.Yes)
{
var isSuccess = false;
var msg = "Deleting";
fxsp = FXSPbal.GetByID(rectype, Convert.ToDateTime(effectivedate));
if (FXSPbal.Delete(fxsp))
{
isSuccess = true;
}
if (isSuccess)
{
MessageHelpers.ShowInfo(msg + " Successful!");
RefreshGrid();
}
else
{
MessageHelpers.ShowWarning(msg + " Failed!");
}
}
}
public Boolean Update(tbl_000_FXSP record)
{
using (var dbContextTransaction = db.Database.BeginTransaction())
{
try
{
var existrecord = GetByID(record.RecType, record.EffectiveDate);
db.Entry(existrecord).GetDatabaseValues().SetValues(record);
db.SaveChanges();
dbContextTransaction.Commit();
return(true);
}
catch (Exception ex)
{
dbContextTransaction.Rollback();
throw ex;
}
}
}
public Boolean Delete(tbl_000_FXSP record)
{
using (var dbContextTransaction = db.Database.BeginTransaction())
{
try
{
var existrecord = GetByID(record.RecType, record.EffectiveDate);
db.FXSPList.Remove(existrecord);
db.SaveChanges();
dbContextTransaction.Commit();
return(true);
}
catch (Exception ex)
{
dbContextTransaction.Commit();
throw ex;
}
}
}
public Boolean Update(tbl_000_FXSP record)
{
try
{
if (record == null)
{
throw new Exception("Invalid Parameter!");
}
if (!fxspdal.IsExistID(record.RecType, record.EffectiveDate))
{
throw new Exception("Record does not exist!");
}
return(fxspdal.Update(record));
}
catch (Exception ex)
{
throw ex;
}
}
public Boolean Save(tbl_000_FXSP record)
{
try
{
if (record == null)
{
throw new Exception("Invalid Parameter!");
}
//if (fxspdal.IsExistType(record.RecType))
//{
// throw new Exception("Type already taken!");
//}
if (fxspdal.IsExistID(record.RecType, record.EffectiveDate))
{
throw new Exception("ID already taken!");
}
return(fxspdal.Save(record));
}
catch (Exception ex)
{
throw ex;
}
}
private void AssignRecord(Boolean IsSave)
{
try
{
if (IsSave)
{
fxsp.RecType = mcboType.SelectedItem.ToString();
fxsp.EffectiveDate = Convert.ToDateTime(mdtpEffectiveDate.Value.Date);
fxsp.Rate = Convert.ToDecimal(BPSUtilitiesV1.NZ(mtxtRate.Text, 0));
//For Testing
fxsp.YearUsed = UserSettings.LogInYear;
fxsp.CreatedBy = UserSettings.Username;
fxsp.CreatedDate = DateTime.Now;
fxsp.UpdatedBy = UserSettings.Username;
fxsp.UpdatedDate = DateTime.Now;
//end
}
else
{
fxsp = fxspbal.GetByID(RecType, Convert.ToDateTime(EffectiveDate));
if (fxsp != null)
{
mcboType.SelectedItem = fxsp.RecType;
mdtpEffectiveDate.Value = fxsp.EffectiveDate;
mtxtRate.Text = fxsp.Rate.ToString();
}
else
{
throw new Exception("Record doesn't exist!");
}
}
}
catch (Exception ex)
{
throw ex;
}
}
public void RemoveYear()
{
try
{
FormHelpers.CursorWait(true);
var recyear = mgridYearList.SelectedRows[0].Cells["colYear"].Value.ToString();
if (MessageHelpers.ShowQuestion("Are you sure you want to remove this year?") == DialogResult.Yes)
{
var RemovingisSuccess = false;
var msg = "Removing";
fxsp = yearbal.CheckFXSPYear(Convert.ToInt32(recyear));
cat = yearbal.CheckCatYear(Convert.ToInt32(recyear));
if (yearbal.Remove(Convert.ToInt32(recyear)))
{
RemovingisSuccess = true;
}
if (RemovingisSuccess)
{
MessageHelpers.ShowInfo(msg + " Successful!");
RefreshGrid();
}
else
{
MessageHelpers.ShowWarning(msg + " Failed!");
}
}
}
catch (Exception ex)
{
MessageHelpers.ShowError(ex.Message);
}
finally
{
FormHelpers.CursorWait(false);
}
}
