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();
}
private void TestConnection()
{
try
{
AssignRecords(true);
SetBALConnection.SetConnectionString(AppConnectionString.ConnectionString);
compbal = new CompanyBAL();
comp = compbal.GetByID(1);
AppSettings.CompanyProfile = comp;
}
catch (Exception ex)
{
throw ex;
}
}
public Boolean Save(tbl_000_COMPANY record)
{
using (var dbContextTransaction = db.Database.BeginTransaction())
{
try
{
db.CompanyList.Add(record);
db.SaveChanges();
dbContextTransaction.Commit();
return(true);
}
catch (Exception ex)
{
dbContextTransaction.Rollback();
throw ex;
}
}
}
private void AssignRecord(Boolean IsSave)
{
try
{
if (IsSave)
{
comp.COMPANY = mtxtCompany.Text;
comp.SHORTNAME = mtxtShortName.Text;
comp.ADDRESS1 = mtxtAddress1.Text;
comp.ADDRESS2 = mtxtAddress2.Text;
//comp.IsActive = mcbActive.Checked;
comp.TELNOS = mtxtTelNos.Text;
comp.MOBILENOS = mtxtMobileNos.Text;
comp.FAXNOS = mtxtFaxNos.Text;
comp.EMAIL = mtxtEmail.Text;
}
else
{
comp = compbal.GetByID(compID);
if (comp != null)
{
mtxtCompany.Text = comp.COMPANY;
mtxtShortName.Text = comp.SHORTNAME;
mtxtAddress1.Text = comp.ADDRESS1;
mtxtAddress2.Text = comp.ADDRESS2;
//mcbActive.Checked=comp.IsActive;
mtxtTelNos.Text = comp.TELNOS;
mtxtMobileNos.Text = comp.MOBILENOS;
mtxtFaxNos.Text = comp.FAXNOS;
mtxtEmail.Text = comp.EMAIL;
}
else
{
throw new Exception("Record doesn't exist!");
}
}
RefreshGrid();
}
catch (Exception ex)
{
throw ex;
}
}
public Boolean Update(tbl_000_COMPANY record)
{
using (var dbContextTransaction = db.Database.BeginTransaction())
{
try
{
var existrecord = GetByID(record.ID);
db.Entry(existrecord).CurrentValues.SetValues(record);
db.SaveChanges();
dbContextTransaction.Commit();
return(true);
}
catch (Exception ex)
{
dbContextTransaction.Rollback();
throw ex;
}
}
}
public Boolean Update(tbl_000_COMPANY record)
{
try
{
if (record == null)
{
throw new Exception("Invalid Parameter");
}
if (!compdal.IsExistID(record.ID))
{
throw new Exception("Record does not exist!");
}
return(compdal.Update(record));
}
catch (Exception ex)
{
throw ex;
}
}
