private void btnLastBillPrint_Click(object sender, EventArgs e)
{
try
{
DataSet dsLastBillDetails = new BillingRepository().GetLastBill(daySequenceID, billObj.LastBillID);
Bill LastBillObj = Utility.GetBill(dsLastBillDetails);
rptBill rpt = new rptBill(LastBillObj.dtBillDetails, LastBillObj.dtMopValues);
rpt.Parameters["GSTIN"].Value = "37AADFV6514H1Z2";
rpt.Parameters["FSSAI"].Value = "10114004000548";
rpt.Parameters["Address"].Value = Utility.branchinfo.BranchAddress;
rpt.Parameters["BillDate"].Value = DateTime.Now;
rpt.Parameters["BillNumber"].Value = LastBillObj.BillNumber;
rpt.Parameters["BranchName"].Value = Utility.branchinfo.BranchName;
rpt.Parameters["CounterName"].Value = Utility.branchinfo.BranchCounterName;
rpt.Parameters["Phone"].Value = Utility.branchinfo.PhoneNumber;
rpt.Parameters["UserName"].Value = Utility.logininfo.UserFullName;
rpt.Parameters["RoundingFactor"].Value = LastBillObj.Rounding;
rpt.Parameters["IsDuplicate"].Value = true;
rpt.Print();
txtItemCode.Focus();
}
catch (Exception ex)
{
XtraMessageBox.Show(ex.Message);
}
}
public static void Get()
{
IBillingRepository <Shipper> shippers = new BillingRepository <Shipper>(Help.Context);
IBillingRepository <Town> towns = new BillingRepository <Town>(Help.Context);
DataTable rawData = Help.OpenExcel("Shippers");
int N = 0;
foreach (DataRow row in rawData.Rows)
{
int oldId = Help.getInteger(row, 0);
string zip = Help.getString(row, 1);
Town town = towns.Get().FirstOrDefault(x => x.Zip == zip);
Shipper ship = new Shipper()
{
Name = Help.getString(row, 2),
Address = Help.getString(row, 3),
Town = town
};
N++;
shippers.Insert(ship);
shippers.Commit();
Help.dicShip.Add(oldId, ship.Id);
}
Console.WriteLine(N);
}
public List <ReportViewModel> GetReportData(string identification, string entity)
{
billing = new BillingRepository();
var list = billing.GetReportBaseonParameters(identification, entity);
return(list);
}
public static void Get()
{
IBillingRepository <Procurement> procurements = new BillingRepository <Procurement>(Help.Context);
IBillingRepository <Supplier> suppliers = new BillingRepository <Supplier>(Help.Context);
IBillingRepository <Product> products = new BillingRepository <Product>(Help.Context);
DataTable rawData = Help.OpenExcel("Procurements");
int N = 0;
foreach (DataRow row in rawData.Rows)
{
Supplier supplier = suppliers.Get(Help.dicSupp[Help.getInteger(row, 2)]);
Product product = products.Get(Help.dicProd[Help.getInteger(row, 3)]);
Procurement procurement = new Procurement()
{
Document = Help.getString(row, 0),
Date = Help.getDate(row, 1),
Supplier = supplier,
Product = product,
Quantity = Help.getInteger(row, 4),
Price = Help.getDouble(row, 5)
};
N++;
procurements.Insert(procurement);
}
procurements.Commit();
Console.WriteLine(N);
}
public static void Get()
{
IBillingRepository <Customer> customers = new BillingRepository <Customer>(Help.Context);
IBillingRepository <Town> towns = new BillingRepository <Town>(Help.Context);
DataTable rawData = Help.OpenExcel("Customers");
int N = 0;
foreach (DataRow row in rawData.Rows)
{
try
{
int oldId = Help.getInteger(row, 0);
string zip = Help.getString(row, 2);
Customer customer = new Customer()
{
Name = Help.getString(row, 1),
Address = Help.getString(row, 3),
Town = towns.Get().FirstOrDefault(x => x.Zip == zip)
};
customers.Insert(customer);
customers.Commit();
N++;
Help.dicCust.Add(oldId, customer.Id);
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
}
}
Console.WriteLine(N);
}
protected void btnAddBillingItem_Click(object sender, EventArgs e)
{
int bookingId = DataUtil.GetBookingIdFromGiffiId(double.Parse(lblGiffiRef.Text));
BillingRepository repo = new BillingRepository();
var arrCodeMap = ddlAddCode.SelectedValue.Split(',');
decimal billingAmount = 0;
decimal payoutAmount = 0;
string errorMsg = string.Empty;
int codeId = 0;
if (bookingId < Constants.InitBookingId)
{
errorMsg = string.Format("ERROR!!! Invalid bookingId={0}.", bookingId);
AlertMessage(errorMsg);
}
else if (arrCodeMap == null || arrCodeMap.Count() == 0 || !int.TryParse(arrCodeMap[0], out codeId))
{
errorMsg = string.Format("ERROR!!! Parsing AccountingCode from input.");
AlertMessage(errorMsg);
}
else if (!decimal.TryParse(txtAddBillingAmount.Text, out billingAmount) ||
!decimal.TryParse(txtAddPayoutAmount.Text, out payoutAmount))
{
errorMsg = string.Format("ERROR!!! INVALID Billing={0} or Payout={1}.", txtAddBillingAmount.Text, txtAddPayoutAmount.Text);
AlertMessage(errorMsg);
}
else if (payoutAmount > billingAmount)
{
errorMsg = string.Format("ERROR!!! Payout={1} cannot greater than Billing={0} amount.", txtAddBillingAmount.Text, txtAddPayoutAmount.Text);
AlertMessage(errorMsg);
}
else if (billingAmount <= 0 || payoutAmount < 0)
{
errorMsg = string.Format("ERROR!!! Billing={0} or Payout={1} invalid amount.", txtAddBillingAmount.Text, txtAddPayoutAmount.Text);
AlertMessage(errorMsg);
}
else if (ddlAddVendor.SelectedValue == "0")
{
errorMsg = string.Format("ERROR!!! Need to choose a vendor.");
AlertMessage(errorMsg);
}
else
{
if (repo.InsertBillingItem(bookingId, int.Parse(arrCodeMap[0]), 1, txtAddDescription.Text, billingAmount, payoutAmount, int.Parse(ddlAddVendor.SelectedValue.ToString())))
{
gvInvoice.DataSource = DataUtil.GetBillingItems(bookingId);
gvInvoice.DataBind();
ddlAddCode.SelectedIndex = -1;
txtAddDescription.Text = "";
txtAddBillingAmount.Text = "";
txtAddBillingAmount.Enabled = true;
txtAddPayoutAmount.Text = "";
txtAddPayoutAmount.Enabled = true;
}
}
}
public static void Get()
{
IBillingRepository <Town> towns = new BillingRepository <Town>(Help.Context);
DataTable rawData = Help.OpenExcel("Towns");
int N = 0;
foreach (DataRow row in rawData.Rows)
{
try
{
Town town = new Town()
{
Zip = Help.getString(row, 0),
Name = Help.getString(row, 1),
Region = (Region)Help.getInteger(row, 2)
};
N++;
towns.Insert(town);
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
}
}
towns.Commit();
Console.WriteLine(N);
}
public static void Get()
{
IBillingRepository <Category> categories = new BillingRepository <Category>(Help.Context);
DataTable rawData = Help.OpenExcel("Categories");
int N = 0;
foreach (DataRow row in rawData.Rows)
{
try
{
int oldId = Help.getInteger(row, 0);
Category cat = new Category()
{
Name = Help.getString(row, 1)
};
N++;
categories.Insert(cat);
categories.Commit();
Help.dicCatt.Add(oldId, cat.Id);
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
}
}
Console.WriteLine(N);
}
public static void Get()
{
IBillingRepository <Invoice> invoices = new BillingRepository <Invoice>(Help.Context);
IBillingRepository <Shipper> shippers = new BillingRepository <Shipper>(Help.Context);
IBillingRepository <Agent> agents = new BillingRepository <Agent>(Help.Context);
IBillingRepository <Customer> customers = new BillingRepository <Customer>(Help.Context);
DataTable rawData = Help.OpenExcel("Invoices");
int N = 0;
foreach (DataRow row in rawData.Rows)
{
Shipper shipper = shippers.Get(Help.dicShip[Help.getInteger(row, 3)]);
Agent agent = agents.Get(Help.dicAgen[Help.getInteger(row, 4)]);
Customer customer = customers.Get(Help.dicCust[Help.getInteger(row, 5)]);
Invoice invoice = new Invoice()
{
InvoiceNo = Help.getString(row, 0),
Date = Help.getDate(row, 1),
ShippedOn = Help.getDate(row, 2),
Shipper = shipper,
Agent = agent,
Customer = customer,
Vat = Help.getDouble(row, 6),
Shipping = Help.getDouble(row, 7)
};
N++;
invoices.Insert(invoice);
}
invoices.Commit();
Console.WriteLine(N);
}
public static void Get()
{
IBillingRepository <Item> items = new BillingRepository <Item>(Help.Context);
IBillingRepository <Invoice> invoices = new BillingRepository <Invoice>(Help.Context);
IBillingRepository <Product> products = new BillingRepository <Product>(Help.Context);
DataTable rawData = Help.OpenExcel("Items");
int N = 0;
foreach (DataRow row in rawData.Rows)
{
string invoiceNo = Help.getString(row, 0);
Invoice invoice = invoices.Get().FirstOrDefault(x => x.InvoiceNo == invoiceNo);
Product product = products.Get(Help.dicProd[Help.getInteger(row, 1)]);
Item item = new Item()
{
Invoice = invoice,
Product = product,
Quantity = Help.getInteger(row, 2),
Price = Help.getDouble(row, 3)
};
N++;
items.Insert(item);
}
items.Commit();
Console.WriteLine(N);
}
public static void Get()
{
IBillingRepository <Event> histories = new BillingRepository <Event>(Help.Context);
IBillingRepository <Invoice> invoices = new BillingRepository <Invoice>(Help.Context);
int N = 0;
DataTable rawData = Help.OpenExcel("Histories");
foreach (DataRow row in rawData.Rows)
{
try
{
string invoiceNo = Help.getString(row, 0);
Event item = new Event()
{
Invoice = invoices.Get().FirstOrDefault(x => x.InvoiceNo == invoiceNo),
Date = Help.getDate(row, 1),
Status = (Status)Help.getInteger(row, 2)
};
histories.Insert(item);
N++;
}
catch (System.Exception ex)
{
System.Console.WriteLine(ex.Message);
}
}
histories.Commit();
Console.WriteLine(N);
}
private void btnSave_Click(object sender, EventArgs e)
{
try
{
int dayClosureid = new BillingRepository().SaveDayClosure(Utility.branchinfo.BranchCounterID,
gcDenomination.DataSource as DataTable, gcMOP.DataSource as DataTable,
Utility.logininfo.UserID, txtRefundAmount.EditValue, daySequenceID);
DayClosed = true;
DataSet ds = new BillingRepository().GetDayClosureForReport(dayClosureid);
rptDayClosure rpt = new rptDayClosure(ds);
rpt.Parameters["Address"].Value = Utility.branchinfo.BranchAddress;
rpt.Parameters["Phone"].Value = Utility.branchinfo.PhoneNumber;
rpt.Parameters["CounterName"].Value = Utility.branchinfo.BranchCounterName;
rpt.Parameters["UserName"].Value = Utility.logininfo.UserName;
rpt.Print();
rpt.Print();
SplashScreenManager.ShowForm(null, typeof(frmWaitForm), true, true, false);
Utility.StartSync(null);
SplashScreenManager.CloseForm();
this.Close();
}
catch (Exception ex)
{
XtraMessageBox.Show(ex.Message);
}
}
public static void Get()
{
IBillingRepository <Product> products = new BillingRepository <Product>(Help.Context);
IBillingRepository <Stock> stocks = new BillingRepository <Stock>(Help.Context);
IBillingRepository <Category> categories = new BillingRepository <Category>(Help.Context);
DataTable rawData = Help.OpenExcel("Products");
int N = 0;
foreach (DataRow row in rawData.Rows)
{
int oldId = Help.getInteger(row, 0);
Product prod = new Product()
{
Name = Help.getString(row, 1),
Unit = Help.getString(row, 2),
Price = Help.getDouble(row, 4),
Category = categories.Get(Help.dicCatt[Help.getInteger(row, 3)])
};
N++;
products.Insert(prod);
products.Commit();
stocks.Insert(new Stock()
{
Id = prod.Id
});
products.Commit();
Help.dicProd.Add(oldId, prod.Id);
}
Console.WriteLine(N);
}
public static void Get()
{
IBillingRepository <Agent> agents = new BillingRepository <Agent>(Help.Context);
IBillingRepository <Town> towns = new BillingRepository <Town>(Help.Context);
DataTable rawData = Help.OpenExcel("Agents");
int N = 0;
foreach (DataRow row in rawData.Rows)
{
int oldId = Help.getInteger(row, 0);
Agent agent = new Agent()
{
Name = Help.getString(row, 1)
};
N++;
string[] Zone = Help.getString(row, 2).Split('.');
foreach (string Z in Zone)
{
Region R = (Region)Convert.ToInt32(Z);
var area = towns.Get().Where(x => x.Region == R).ToList();
foreach (var city in area)
{
agent.Towns.Add(city);
}
}
agents.Insert(agent);
agents.Commit();
Help.dicAgen.Add(oldId, agent.Id);
}
Console.WriteLine(N);
}
public static DataTable GetBillingItems(double giffiRef)
{
int bookingId = DataUtil.GetBookingIdFromGiffiId(giffiRef);
BillingRepository billRepo = new BillingRepository();
return(billRepo.GetBillingItem(bookingId));
}
protected void SelectedSearch_Click(object sender, EventArgs e)
{
double giffiRef = -1;
BillingRepository repo = new BillingRepository();
if (!string.IsNullOrEmpty(txtSearchBox.Text) && double.TryParse(txtSearchBox.Text, out giffiRef) && giffiRef > 10000)
{
lblGiffiRef.Text = txtSearchBox.Text;
lblGiffiRef.DataBind();
int bookingId = DataUtil.GetBookingIdFromGiffiId(giffiRef);
hfBookingId.Value = bookingId.ToString();
Company c = GetCompanyInfo(bookingId);
Booking b = GetBookingInfo(bookingId);
string cityZip = string.Join(", ", c.City.Trim(), c.State.Trim(), c.ZipCode.Trim());
string cpInfo = string.Join("</br>", c.CompanyName, c.Address, cityZip, c.Country);
lblBillTo.Text = cpInfo;
lblBillTo.DataBind();
lblDescription.Text = b.Commodity.Trim();
lblYourRef.Text = b.ShipperRefNo;
lblInvoiceDate.Text = b.CreatedTime.ToString("d");
lblVoyage.Text = b.Voyage;
lblOrigin.Text = b.Origin;
lblDestination.Text = b.Destination;
gvInvoice.DataSource = DataUtil.GetBillingItems(giffiRef);
gvInvoice.DataBind();
Dictionary <string, string> codes = GetAcctCodeMapIdWithName();
codes.Add("--Select--", "0");
ddlAddCode.DataSource = codes.OrderByDescending(x => x.Key);
ddlAddCode.DataTextField = "Key";
ddlAddCode.DataValueField = "Key";
ddlAddCode.DataBind();
ddlAddVendor.DataSource = GetVendorInfo();
ddlAddVendor.DataTextField = "Value";
ddlAddVendor.DataValueField = "Key";
ddlAddVendor.DataBind();
tbAddBilling.Visible = true;
tbAddBilling.DataBind();
btnPreviewInvoice.Visible = true;
btnPayoutPreview.Visible = true;
txtSearchBox.Text = string.Empty;
}
}
public static void Get()
{
IBillingRepository <ApiUser> apiUsers = new BillingRepository <ApiUser>(Help.Context);
apiUsers.Insert(new ApiUser()
{
Name = "Billing",
AppId = "R2lnaVNjaG9vbA==",
Secret = "TWlzdHJhbFRhbGVudHM="
});
apiUsers.Commit();
}
void WhenAFileDoesNotExist_ThenAnEmptyObjectShouldBeReturned()
{
// Arrange
var id = 0;
var expected = new Bill();
var repository = new BillingRepository();
// Act
var actual = repository.Get(id);
// Assert
Assert.Null(actual);
}
void WhenABillIsRequested_ThenABillShouldBeReturned()
{
// Arrange
var id = 1;
var expected = new Bill();
var repository = new BillingRepository();
// Act
var actual = repository.Get(id);
// Assert
Assert.NotNull(actual.Statement.Due);
}
protected void gvInvoice_RowDeleting(object sender, GridViewDeleteEventArgs e)
{
int bookingId = DataUtil.GetBookingIdFromGiffiId(double.Parse(lblGiffiRef.Text));
int billingItemId = (int)gvInvoice.DataKeys[e.RowIndex].Value;
BillingRepository repo = new BillingRepository();
repo.DeleteItem(billingItemId, bookingId);
gvInvoice.DataSource = DataUtil.GetBillingItems(bookingId);
gvInvoice.EditIndex = -1;
gvInvoice.DataBind();
}
public frmDayClosure(int daySeqID)
{
InitializeComponent();
DataSet dsDayClosure = new BillingRepository().GetDayClosure();
gcDenomination.DataSource = dsDayClosure.Tables[0];
gcMOP.DataSource = dsDayClosure.Tables[1];
gvDenomination.FocusedRowHandle = 0;
gvDenomination.FocusedColumn = gcQuantity;
txtRefundAmount.EditValue = dsDayClosure.Tables[2].Rows[0]["REFUNDAMOUNT"];
updateSummary();
daySequenceID = daySeqID;
this.gvDenomination.Appearance.FocusedCell.BackColor = System.Drawing.Color.SaddleBrown;
this.gvDenomination.Appearance.FocusedCell.Font = new System.Drawing.Font("Arial", 10F, System.Drawing.FontStyle.Bold);
this.gvDenomination.Appearance.FocusedCell.ForeColor = System.Drawing.Color.White;
this.gvDenomination.Appearance.FocusedCell.Options.UseBackColor = true;
this.gvDenomination.Appearance.FocusedCell.Options.UseFont = true;
this.gvDenomination.Appearance.FocusedCell.Options.UseForeColor = true;
this.gvDenomination.Appearance.FocusedRow.BackColor = System.Drawing.Color.White;
this.gvDenomination.Appearance.FocusedRow.Font = new System.Drawing.Font("Arial", 10F, System.Drawing.FontStyle.Bold);
this.gvDenomination.Appearance.FocusedRow.Options.UseBackColor = true;
this.gvDenomination.Appearance.FocusedRow.Options.UseFont = true;
this.gvDenomination.Appearance.FooterPanel.Font = new System.Drawing.Font("Arial", 14F, System.Drawing.FontStyle.Bold);
this.gvDenomination.Appearance.FooterPanel.Options.UseFont = true;
this.gvDenomination.Appearance.HeaderPanel.Font = new System.Drawing.Font("Arial", 9F, System.Drawing.FontStyle.Bold);
this.gvDenomination.Appearance.HeaderPanel.Options.UseFont = true;
this.gvDenomination.Appearance.Row.Font = new System.Drawing.Font("Arial", 9F, System.Drawing.FontStyle.Bold);
this.gvDenomination.Appearance.Row.Options.UseFont = true;
this.gvMOP.Appearance.FocusedCell.BackColor = System.Drawing.Color.SaddleBrown;
this.gvMOP.Appearance.FocusedCell.Font = new System.Drawing.Font("Arial", 10F, System.Drawing.FontStyle.Bold);
this.gvMOP.Appearance.FocusedCell.ForeColor = System.Drawing.Color.White;
this.gvMOP.Appearance.FocusedCell.Options.UseBackColor = true;
this.gvMOP.Appearance.FocusedCell.Options.UseFont = true;
this.gvMOP.Appearance.FocusedCell.Options.UseForeColor = true;
this.gvMOP.Appearance.FocusedRow.BackColor = System.Drawing.Color.White;
this.gvMOP.Appearance.FocusedRow.Font = new System.Drawing.Font("Arial", 10F, System.Drawing.FontStyle.Bold);
this.gvMOP.Appearance.FocusedRow.Options.UseBackColor = true;
this.gvMOP.Appearance.FocusedRow.Options.UseFont = true;
this.gvMOP.Appearance.FooterPanel.Font = new System.Drawing.Font("Arial", 14F, System.Drawing.FontStyle.Bold);
this.gvMOP.Appearance.FooterPanel.Options.UseFont = true;
this.gvMOP.Appearance.HeaderPanel.Font = new System.Drawing.Font("Arial", 9F, System.Drawing.FontStyle.Bold);
this.gvMOP.Appearance.HeaderPanel.Options.UseFont = true;
this.gvMOP.Appearance.Row.Font = new System.Drawing.Font("Arial", 9F, System.Drawing.FontStyle.Bold);
this.gvMOP.Appearance.Row.Options.UseFont = true;
}
public bool Bill(int customer, int seller, string articles)
{
billing = new BillingRepository();
var list = (articles.Split(',').Select(x => int.Parse(x))).ToArray();
var bill = billing.BillCustomer(customer, seller, list);
if (bill != null)
{
try
{
var client = new Contabilidad.ContabilidadClient();
var debito = new entradaContableDet();
var credito = new entradaContableDet();
debito.monto = (float)bill.Amount;
credito.monto = (float)bill.Amount;
credito.cuentaContable = "6";
debito.cuentaContable = "13";
credito.tipoMovimiento = "CR";
debito.tipoMovimiento = "DB";
entradaContableDet[] lise = new entradaContableDet[2];
lise[0] = debito;
lise[1] = credito;
Contabilidad.entradaContable asiento = new Contabilidad.entradaContable();
asiento.auxiliar = "3";
asiento.descripcion = "Grupo de Jose Agustin Reinoso";
asiento.entradasContables = lise;
var response = client.crearAsiento(asiento);
}
catch (Exception e)
{
return(false);
}
}
return(true);
}
public static void Get()
{
IBillingRepository <Product> products = new BillingRepository <Product>(Help.Context);
IBillingRepository <Category> categories = new BillingRepository <Category>(Help.Context);
IBillingRepository <Stock> stocks = new BillingRepository <Stock>(Help.Context);
Random r = new Random();
DataTable rawData = Help.OpenExcel("Products");
int N = 0;
foreach (DataRow row in rawData.Rows)
{
try
{
int oldId = Help.getInteger(row, 0);
Category category = categories.Get(Help.dicCatt[Help.getInteger(row, 3)]);
Product product = new Product()
{
Name = Help.getString(row, 1),
Unit = Help.getString(row, 2),
Price = Help.getDouble(row, 4),
Category = category,
};
N++;
products.Insert(product);
products.Commit();
stocks.Insert(new Stock()
{
Id = product.Id,
Input = r.Next(100, 300),
Output = r.Next(0, 100)
});
products.Commit();
Help.dicProd.Add(oldId, product.Id);
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
}
}
Console.WriteLine(N);
}
protected void gvInvoice_RowUpdating(object sender, GridViewUpdateEventArgs e)
{
string erroMsg = string.Empty;
GridViewRow row = gvInvoice.Rows[e.RowIndex];
int billingItemId = (int)gvInvoice.DataKeys[e.RowIndex].Value;
int bookingId = DataUtil.GetBookingIdFromGiffiId(double.Parse(lblGiffiRef.Text));
BillingItem bi = null;
try
{
bi = new BillingItem
{
Id = billingItemId,
BookingId = bookingId,
CodeId = int.Parse((row.FindControl("txtCodeId") as TextBox).Text.Trim()),
Description = (row.FindControl("txtDescription") as TextBox).Text.Trim(),
BillingAmount = decimal.Parse((row.FindControl("txtBillingAmount") as TextBox).Text.Trim()),
PayoutAmount = decimal.Parse((row.FindControl("txtPayoutAmount") as TextBox).Text.Trim())
};
BillingRepository repo = new BillingRepository();
if (repo.UpdateBillingItem(bi))
{
gvInvoice.EditIndex = -1;
gvInvoice.DataSource = DataUtil.GetBillingItems(bookingId);
gvInvoice.DataBind();
}
}
catch (SqlException se)
{
erroMsg = string.Format("Unable to insert freight to database. SQLException={0}", bookingId, se.Message);
AlertMessage(erroMsg);
}
catch (Exception ex)
{
erroMsg = string.Format("Unable to insert freight due to an invalid entry. Exception={0}", bookingId, ex.Message);
AlertMessage(erroMsg);
}
}
public static void Get()
{
IBillingRepository <Agent> agents = new BillingRepository <Agent>(Help.Context);
IBillingRepository <Town> towns = new BillingRepository <Town>(Help.Context);
int N = 0;
DataTable rawData = Help.OpenExcel("Agents");
foreach (DataRow row in rawData.Rows)
{
try
{
int oldId = Help.getInteger(row, 0);
Agent agent = new Agent()
{
Name = Help.getString(row, 1)
};
string[] zones = Help.getString(row, 2).Split(',');
foreach (string zone in zones)
{
Region r = (Region)Convert.ToInt32(zone);
var areas = towns.Get().Where(x => x.Region == r).ToList();
foreach (var city in areas)
{
agent.Towns.Add(city);
}
}
agents.Insert(agent);
agents.Commit();
N++;
Help.dicAgen.Add(oldId, agent.Id);
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
}
}
Console.WriteLine(N);
}
public frmDraftList(int daySequenceID)
{
InitializeComponent();
DataTable dtDraftBills = new BillingRepository().GetDraftBills(daySequenceID);
gcDraftBills.DataSource = dtDraftBills;
this.gvDraftBills.Appearance.FocusedCell.BackColor = System.Drawing.Color.White;
this.gvDraftBills.Appearance.FocusedCell.Font = new System.Drawing.Font("Arial", 10F, System.Drawing.FontStyle.Bold);
this.gvDraftBills.Appearance.FocusedCell.Options.UseBackColor = true;
this.gvDraftBills.Appearance.FocusedCell.Options.UseFont = true;
this.gvDraftBills.Appearance.FocusedRow.BackColor = System.Drawing.Color.White;
this.gvDraftBills.Appearance.FocusedRow.Font = new System.Drawing.Font("Arial", 10F, System.Drawing.FontStyle.Bold);
this.gvDraftBills.Appearance.FocusedRow.Options.UseBackColor = true;
this.gvDraftBills.Appearance.FocusedRow.Options.UseFont = true;
this.gvDraftBills.Appearance.FooterPanel.Font = new System.Drawing.Font("Arial", 14F, System.Drawing.FontStyle.Bold);
this.gvDraftBills.Appearance.FooterPanel.Options.UseFont = true;
this.gvDraftBills.Appearance.HeaderPanel.Font = new System.Drawing.Font("Arial", 9F, System.Drawing.FontStyle.Bold);
this.gvDraftBills.Appearance.HeaderPanel.Options.UseFont = true;
this.gvDraftBills.Appearance.Row.Font = new System.Drawing.Font("Arial", 9F, System.Drawing.FontStyle.Bold);
this.gvDraftBills.Appearance.Row.Options.UseFont = true;
}
public ApplicationService(AccountRepository accountRepository, BillingRepository billingRepository)
{
_accountRepository = accountRepository;
_billingRepository = billingRepository;
}
private static void UseSqlServer()
{
var dbOptions = new DbContextOptionsBuilder <ApplicationContext>().UseSqlServer("Data Source=LAPTOP-7KC3O54G\\RECEPTION; Initial Catalog = Billing8; User Id = sa; Password = sa@12345;");
Repository = new BillingRepository(dbOptions);
}
public BillingController()
{
_repository = new BillingRepository();
}
public static DataTable GetPayoutItems(int bookingId)
{
BillingRepository repo = new BillingRepository();
return(repo.GetPayoutItems(bookingId));
}
public static DataTable GetBillingItems(int bookingId)
{
BillingRepository billRepo = new BillingRepository();
return(billRepo.GetBillingItem(bookingId));
}
