private void fillSTTKH()
{
DataTable khachHangCLHD = DataTier.getUnbilledCustomer(tramComboBox.SelectedValue.ToString(), int.Parse(thangComboBox.Text), int.Parse(namComboBox.Text));
soThuTuComboBox.DataSource = khachHangCLHD;
soThuTuComboBox.DisplayMember = "CustomerNumber";
soThuTuComboBox.ValueMember = "CustomerID";
if (soThuTuComboBox.Items.Count > 0)
{
soThuTuComboBox.SelectedIndex = 0;
fillKHDetails();
xuatHoaDonButton.Visible = true;
printToolStripMenuItem.Enabled = true;
mayInCheckBox.Enabled = true;
vanBanCheckBox.Enabled = true;
}
else
{
soThuTuComboBox.Text = string.Empty;
clearTextBoxes();
xuatHoaDonButton.Visible = false;
printToolStripMenuItem.Enabled = false;
mayInCheckBox.Enabled = false;
vanBanCheckBox.Enabled = false;
}
soKhachTrongTram = DataTier.XacDinhSTTMax(tramComboBox.SelectedValue.ToString());
messageLabel.Text = "Có " + khachHangCLHD.Rows.Count.ToString() + " khách chưa lập hóa đơn trong tháng " + thangComboBox.Text + "/" + namComboBox.Text;
}
private void soNhatKyChungForm_Load(object sender, EventArgs e)
{
this.cboYear.Text = DateTime.Today.Year.ToString();
this.cboYearSoCai.Text = DateTime.Today.Year.ToString();
this.tbl_NhatKyChungTableAdapter.Fill(this.eMSDBDataSet.tbl_NhatKyChung, int.Parse(cboYear.Text));
this.txtSTT.Text = DataTier.getLastestSTTNhatKyChung(cboYear.Text);
}
private void mainForm_Shown(object sender, EventArgs e)
{
if (DataTier.getPassword() != String.Empty)
{
loginForm login = new loginForm();
login.ShowDialog();
}
}
private void GetPriceHistory(string strTicker)
{
DataTier data = new DataTier();
DataTable priceData = data.GetFullPriceHistory(strTicker, 20);
grdPriceHistory.DataSource = priceData;
grdPriceHistory.DataBind();
}
private void danhSachKHForm_Load(object sender, EventArgs e)
{
this.Text = "EMS - Danh Sách Khách Hàng " + tenTram;
dskh = new DanhSachKhachHang();
dskh.SetDataSource(DataTier.getCustomer(StationID));
dskh.SetParameterValue("tenTram", tenTram);
crystalReportViewer1.ReportSource = dskh;
}
public static IUnitOfWork GetUnitOfWork(DataTier dataTier)
{
switch (dataTier)
{
case DataTier.EntityFrameworkCore:
return(new Persistence.EF.UnitOfWork());
}
throw new NotImplementedException();
}
private void LoadCustomerList()
{
bsCustomer.DataSource = DataTier.getCustomerList(cboTramDien.SelectedValue.ToString());
cboMaSoKH.DataSource = bsCustomer;
cboMaSoKH.DisplayMember = "CustomerNumber";
cboMaSoKH.ValueMember = "CustomerID";
txtHoTen.DataBindings.Clear();
txtHoTen.DataBindings.Add("Text", bsCustomer, "Name");
}
private void deleteButton_Click(object sender, EventArgs e)
{
errorProvider1.Clear();
if (!DataTier.editPassword(""))
{
MessageBox.Show("Xóa mật khẩu không thành công, bạn hãy thử lại sau!", "Lỗi", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
this.Close();
}
public static void fillViewHDSX3(string hoaDonID, ViewInvoiceSX3 hd)
{
hd.SetDataSource(DataTier.fillHoaDon(hoaDonID));
hd.SetParameterValue("ngayBatDau", ngayBatDau);
hd.SetParameterValue("ngayKetThuc", ngayKetThuc);
hd.SetParameterValue("giaDien1", giaDien);
hd.SetParameterValue("giaDien2", giaDienSX3_2);
hd.SetParameterValue("ngayKyHD", "Ngày " + ngayKy + "/" + thangKy + "/" + namKy);
hd.SetParameterValue("ngayKyHD2", "Ngày " + ngayKy + " tháng " + thangKy + " năm " + namKy);
hd.SetParameterValue("tongTienBangChu", docChu);
}
public static void setSX3InvoiceParams(string hoaDonID, CrystalDecisions.CrystalReports.Engine.ReportClass hd)
{
hd.SetDataSource(DataTier.fillHoaDon(hoaDonID));
hd.SetParameterValue("ngayBatDau", ngayBatDau);
hd.SetParameterValue("ngayKetThuc", ngayKetThuc);
hd.SetParameterValue("giaDien1", giaDien);
hd.SetParameterValue("giaDien2", giaDienSX3_2);
hd.SetParameterValue("ngayKyHD", "Ngày " + ngayKy + "/" + thangKy + "/" + namKy);
hd.SetParameterValue("ngayKyHD2", "Ngày " + ngayKy + " tháng " + thangKy + " năm " + namKy);
hd.SetParameterValue("tongTienBangChu", docChu);
}
private void fillTram()
{
DataTable station = DataTier.getStation();
tramComboBox.DataSource = station;
tramComboBox.DisplayMember = "Name";
tramComboBox.ValueMember = "StationID";
durationDateComboBox.DataBindings.Add("Text", station, "Duration");
invoiceDateComboBox.DataBindings.Add("Text", station, "InvoiceDate");
signDateComboBox.DataBindings.Add("Text", station, "SignDate");
reportDateComboBox.DataBindings.Add("Text", station, "ReportDate");
}
private void fillKHDetails()
{
tenKhachTextBox.DataBindings.Clear();
diaChiTextBox.DataBindings.Clear();
soHoKhauTextBox.DataBindings.Clear();
maSoThueTextBox.DataBindings.Clear();
Object khachHangDetails = DataTier.getCustomerDetails(soThuTuComboBox.SelectedValue.ToString());
tenKhachTextBox.DataBindings.Add("Text", khachHangDetails, "Name");
diaChiTextBox.DataBindings.Add("Text", khachHangDetails, "Address");
soHoKhauTextBox.DataBindings.Add("Text", khachHangDetails, "HKNumber");
maSoThueTextBox.DataBindings.Add("Text", khachHangDetails, "TaxNumber");
}
private void fillCurrentPrice()
{
ngheoTextBox.Text = DataTier.getPrice("a770acf2-0f54-43ce-8695-10c7c4072c64");
tntTextBox.Text = DataTier.getPrice("7e17ce3d-ea0c-4a6a-9048-47c563991fd6");
SHTextBox.Text = DataTier.getPrice("e00f133e-f43c-4dc5-8ebb-a747200416c9");
//CCTextBox.Text = DataTier.getGiaDien(2);
HCTextBox.Text = DataTier.getPrice("068b5479-814c-4576-86ea-8684b07ffb4a");
KD1TextBox.Text = DataTier.getPrice("0cd8fc10-1369-4b21-9c59-806ada969bdb");
KD2TextBox.Text = DataTier.getPrice("3f4627cb-3ae3-4fcf-86e1-117b1dfcac4d");
SX1TextBox.Text = DataTier.getPrice("a8794644-b056-41dd-b515-bec60477947a");
SX2TextBox.Text = DataTier.getPrice("d4770373-51bb-4d7a-90d1-327c7043cdeb");
SX3TextBox.Text = DataTier.getPrice("422cf080-b750-411d-a895-9550b8950b66");
//giaSX4Label.Text = DataTier.getGiaDien(9);
}
private void fillTram()
{
tramComboBox.DataSource = DataTier.getStation();
tramComboBox.DisplayMember = "Name";
tramComboBox.ValueMember = "StationID";
if (tramComboBox.Items.Count > 0)
{
tramComboBox.SelectedIndex = 0;
viewButton.Enabled = true;
}
else
{
viewButton.Enabled = false;
}
}
private void identifyTotalReport()
{
totalReport = DataTier.getBCTH(tramComboBox.SelectedValue.ToString(), int.Parse(thangComboBox.Text), int.Parse(namComboBox.Text));
clearBinding();
clearTextBoxes();
bindingData();
if (totalReport.Rows.Count > 0)
{
normalMode();
}
else
{
createNewMode();
}
}
protected void ZedGraphWeb1_RenderGraph(System.Drawing.Graphics g, ZedGraph.MasterPane mPane)
{
int nDays = 0;
int nRows = 0;
GraphPane pane = mPane[0];
PointPairList pt = new PointPairList();
double nx;
double ny;
string days = (string)Page.Request.Params["days"];
string ticker = (string)Page.Request.Params["ticker"];
if (ticker != null)
{
ticker = ticker.Trim();
DataTier theDataTier = new DataTier();
if (days == null)
{
nDays = 0;
}
else
{
nDays = Convert.ToInt32(days);
}
DataTable dtTable = theDataTier.GetFullPriceHistory(ticker, nDays);
nRows = dtTable.Rows.Count;
for (int i = 1; i < nRows; i++)
{
ny = Convert.ToDouble(dtTable.Rows[i].ItemArray[1]);
XDate tmpDate = new XDate(Convert.ToDateTime(dtTable.Rows[i].ItemArray[0]));
nx = (double)tmpDate;
pt.Add(nx, ny);
}
pane.XAxis.Type = AxisType.Date;
pane.XAxis.GridDashOff = 0;
LineItem priceCurve = pane.AddCurve("Closing Price", pt, Color.SlateBlue, SymbolType.None);
priceCurve.Line.Width = 2.0F;
pane.AxisFill = new Fill(Color.White, Color.AntiqueWhite);
pane.XAxis.MinGrace = 0;
pane.XAxis.MaxGrace = 0;
pane.YAxis.MinGrace = 0;
pane.YAxis.MaxGrace = 0;
pane.AxisChange(g);
}
}
private void saveButton_Click(object sender, EventArgs e)
{
if (checkInput(SH1TextBox) && checkInput(SH2TextBox) && checkInput(SH3TextBox) && checkInput(SH4TextBox) && checkInput(SH5TextBox) && checkInput(SH6TextBox) && checkInput(HCTextBox) && checkInput(KD1TextBox) && checkInput(KD2TextBox) && checkInput(SX1TextBox) && checkInput(SX2TextBox) && checkInput(SX3TextBox))
{
DataTier.editCurrentPrice("a770acf2-0f54-43ce-8695-10c7c4072c64", ngheoTextBox.Text);
DataTier.editCurrentPrice("7e17ce3d-ea0c-4a6a-9048-47c563991fd6", tntTextBox.Text);
DataTier.editCurrentPrice("e00f133e-f43c-4dc5-8ebb-a747200416c9", SH1TextBox.Text + "," + SH2TextBox.Text + "," + SH3TextBox.Text + "," + SH4TextBox.Text + "," + SH5TextBox.Text + "," + SH6TextBox.Text);
DataTier.editCurrentPrice("068b5479-814c-4576-86ea-8684b07ffb4a", HCTextBox.Text);
DataTier.editCurrentPrice("0cd8fc10-1369-4b21-9c59-806ada969bdb", KD1TextBox.Text);
DataTier.editCurrentPrice("3f4627cb-3ae3-4fcf-86e1-117b1dfcac4d", KD2TextBox.Text);
DataTier.editCurrentPrice("a8794644-b056-41dd-b515-bec60477947a", SX1TextBox.Text);
DataTier.editCurrentPrice("d4770373-51bb-4d7a-90d1-327c7043cdeb", SX2TextBox.Text);
DataTier.editCurrentPrice("422cf080-b750-411d-a895-9550b8950b66", SX3TextBox.Text);
this.Close();
}
}
private void LoadStationList()
{
cboTramDien.DataSource = DataTier.getStation();
cboTramDien.DisplayMember = "Name";
cboTramDien.ValueMember = "StationID";
if (cboTramDien.Items.Count > 0)
{
cboTramDien.SelectedIndex = 0;
LoadCustomerList();
}
else
{
cboMaSoKH.DataSource = null;
cboMaSoKH.Items.Clear();
}
}
private void identifyPassword()
{
password = DataTier.getPassword();
if (password == String.Empty)
{
changePasswordGroupBox.Visible = false;
createPasswordGroupBox.Visible = true;
deleteButton.Visible = false;
}
else
{
changePasswordGroupBox.Visible = true;
createPasswordGroupBox.Visible = false;
deleteButton.Visible = false;
}
}
private void ClearForm()
{
this.txtSTT.Text = DataTier.getLastestSTTNhatKyChung(cboYear.Text);
this.dtpNgayGhiSo.Value = DateTime.Today;
this.txtSoChungTu.Clear();
this.dtpNgayChungTu.Value = DateTime.Today;
this.txtDescription.Clear();
this.txtSoTKDUNo.Clear();
this.txtTienNo.Clear();
this.cbxThueGTGT.Checked = false;
this.txtSoTKDUGTGT.Enabled = false;
this.txtTienNoGTGT.Enabled = false;
this.txtSoTKDUGTGT.Clear();
this.txtTienNoGTGT.Clear();
this.txtSoTKDUCo.Clear();
this.txtTienCo.Clear();
}
public Members()
{
DataTable dt = DataTier.GetDataTable("SELECT * FROM MemberDirectory_Members");
_members = new List <Member>();
foreach (DataRow row in dt.Rows)
{
_members.Add(new Member
{
MemberID = (int)row["MemberID"],
FirstName = row["MemberFirstName"].ToString(),
LastName = row["MemberLastName"].ToString(),
Title = row["MemberTitle"].ToString()
});
}
}
private void fillGiaDien()
{
giaPoorLabel.Text = DataTier.getPrice("a770acf2-0f54-43ce-8695-10c7c4072c64");
giaLowIncome.Text = DataTier.getPrice("7e17ce3d-ea0c-4a6a-9048-47c563991fd6");
String[] giaSH = DataTier.getPrice("e00f133e-f43c-4dc5-8ebb-a747200416c9").Split(',');
giaSH1Label.Text = giaSH[0];
giaSH2Label.Text = giaSH[1];
giaSH3Label.Text = giaSH[2];
giaSH4Label.Text = giaSH[3];
giaSH5Label.Text = giaSH[4];
giaSH6Label.Text = giaSH[5];
giaHCLabel.Text = DataTier.getPrice("068b5479-814c-4576-86ea-8684b07ffb4a");
giaKD1Label.Text = DataTier.getPrice("0cd8fc10-1369-4b21-9c59-806ada969bdb");
giaKD2Label.Text = DataTier.getPrice("3f4627cb-3ae3-4fcf-86e1-117b1dfcac4d");
giaSX1Label.Text = DataTier.getPrice("a8794644-b056-41dd-b515-bec60477947a");
giaSX2Label.Text = DataTier.getPrice("d4770373-51bb-4d7a-90d1-327c7043cdeb");
giaSX3Label.Text = DataTier.getPrice("422cf080-b750-411d-a895-9550b8950b66");
}
private void fillTram()
{
tramComboBox.DataSource = DataTier.getStation();
tramComboBox.DisplayMember = "Name";
tramComboBox.ValueMember = "StationID";
if (tramComboBox.Items.Count > 0)
{
tramComboBox.SelectedIndex = 0;
fillSTTKH();
}
else
{
soThuTuComboBox.DataSource = null;
soThuTuComboBox.Items.Clear();
clearTextBoxes();
}
fillGiaDien();
}
private void fillSoCu()
{
string[] soCu = DataTier.getOldNumber(soThuTuComboBox.SelectedValue.ToString(), int.Parse(thangComboBox.Text), int.Parse(namComboBox.Text));
soCuTextBox.Text = soCu[0];
heSoNhanTextBox.Text = soCu[1];
if (soCu[2] == "a770acf2-0f54-43ce-8695-10c7c4072c64")
{
poorRadioButton.Checked = true;
}
else if (soCu[2] == "7e17ce3d-ea0c-4a6a-9048-47c563991fd6")
{
lowIncomeRadioButton.Checked = true;
}
else if (soCu[2] == "e00f133e-f43c-4dc5-8ebb-a747200416c9")
{
sinhHoatRadioButton.Checked = true;
}
else if (soCu[2] == "068b5479-814c-4576-86ea-8684b07ffb4a")
{
hanhChinhRadioButton.Checked = true;
}
else if (soCu[2] == "0cd8fc10-1369-4b21-9c59-806ada969bdb")
{
kinhDoanh1RadioButton.Checked = true;
}
else if (soCu[2] == "3f4627cb-3ae3-4fcf-86e1-117b1dfcac4d")
{
kinhDoanh2RadioButton.Checked = true;
}
else if (soCu[2] == "a8794644-b056-41dd-b515-bec60477947a")
{
sanXuat1RadioButton.Checked = true;
}
else if (soCu[2] == "d4770373-51bb-4d7a-90d1-327c7043cdeb")
{
sanXuat2RadioButton.Checked = true;
}
else if (soCu[2] == "422cf080-b750-411d-a895-9550b8950b66")
{
sanXuat3RadioButton.Checked = true;
}
poorRadioButton.Enabled = true;
lowIncomeRadioButton.Enabled = true;
}
private void fillTram()
{
tramComboBox.DataSource = DataTier.getStation();
tramComboBox.DisplayMember = "Name";
tramComboBox.ValueMember = "StationID";
if (tramComboBox.Items.Count > 0)
{
tramComboBox.SelectedIndex = 0;
fillSTTKH();
soKhachLabel.Text = tramComboBox.Text + " có: " + DataTier.getCustomerNumber(tramComboBox.SelectedValue.ToString()).Rows.Count.ToString() + " khách";
}
else
{
soThuTuComboBox.DataSource = null;
soThuTuComboBox.Items.Clear();
clearTextBoxes();
soKhachLabel.Text = string.Empty;
}
}
private void fillSTTKH()
{
if (currentMode != "add" && currentMode != "edit" && tramComboBox.Items.Count > 0)
{
soThuTuComboBox.DataSource = DataTier.getCustomerNumber(tramComboBox.SelectedValue.ToString());
soThuTuComboBox.DisplayMember = "CustomerNumber";
soThuTuComboBox.ValueMember = "CustomerID";
if (soThuTuComboBox.Items.Count > 0)
{
soThuTuComboBox.SelectedIndex = 0;
fillKHDetails();
}
else
{
clearTextBoxes();
}
soTTMax = DataTier.XacDinhSTTMax(tramComboBox.SelectedValue.ToString());
soKhachLabel.Text = tramComboBox.Text + " có: " + DataTier.getCustomerNumber(tramComboBox.SelectedValue.ToString()).Rows.Count.ToString() + " khách";
}
}
// Ian Bell - 10/13/2012
// Recieves dictionary with branchNo value.
// Checks:
// 1. branchNo isn't empty
// 2. branchNo doesn't exceed db field length
// 3. branchNo exists in db
// 4. deleting branchNo won't violate foriegn key constraints
// Passes staff info to data tier if it passes all tests
// returns table with appropriate error message if staff info fails any test
public DataSet deleteBranch(Dictionary<String, String> branchNo)
{
DataSet ds = generateErrorDataSet();
String errorMessage = "";
try
{
DataTier dt = new DataTier();
if (branchNo["branchNo"].Length > 0) // ensure that a value was passed
{
if(branchNo["branchNo"].Length > 4)
errorMessage = "The maximum length of a Staff Number is 4 characters";
else if (dt.branchExists(branchNo).Tables[1].Rows[0][0].ToString() != "True")
errorMessage = "No Branch with that Branch Number exists.";
else if (dt.branchNumberConstraintExists(branchNo).Tables[1].Rows[0][0].ToString() == "True")
errorMessage = "You can't delete that Branch while there are Staff and/or Properties for Rent assigned to it.";
}
else
errorMessage = "You must enter a Branch Number.";
if (errorMessage.Length == 0)
dt.deleteBranch(branchNo);
if (errorMessage.Length > 0)
ds.Tables[0].Rows.Add(errorMessage);
}
catch (Exception ex)
{
logError(ex, "BusinessTier", "deleteBranch");
errorMessage = "We've encountered an unexpected difficulty. Please try again later or contact your administrator";
ds.Tables[0].Rows.Add(errorMessage);
}
return ds;
}
private void saveButton_Click(object sender, EventArgs e)
{
errorProvider1.Clear();
if (oldPasswordTextBox.Text != password)
{
errorProvider1.SetError(oldPasswordTextBox, "Mật khẩu bạn nhập vào không hợp lệ!");
errorProvider1.SetIconAlignment(oldPasswordTextBox, ErrorIconAlignment.MiddleLeft);
oldPasswordTextBox.Focus();
oldPasswordTextBox.SelectAll();
}
else if (newPasswordTextBox.Text != confirmPasswordTextBox.Text)
{
errorProvider1.SetError(newPasswordTextBox, "Bạn phải nhập hai lần mật khẩu mới trùng nhau!");
errorProvider1.SetIconAlignment(newPasswordTextBox, ErrorIconAlignment.MiddleLeft);
errorProvider1.SetError(confirmPasswordTextBox, "Bạn phải nhập hai lần mật khẩu mới trùng nhau!");
errorProvider1.SetIconAlignment(confirmPasswordTextBox, ErrorIconAlignment.MiddleLeft);
oldPasswordTextBox.Focus();
oldPasswordTextBox.SelectAll();
}
else
{
if (changePasswordGroupBox.Visible)
{
if (!DataTier.editPassword(newPasswordTextBox.Text))
{
MessageBox.Show("Thay đổi mật khẩu không thành công, bạn hãy thử lại sau!", "Lỗi", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
else if (createPasswordGroupBox.Visible)
{
if (!DataTier.editPassword(passwordTextBox.Text))
{
MessageBox.Show("Tạo mật khẩu mới không thành công, bạn hãy thử lại sau!", "Lỗi", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
this.Close();
}
}
private void btnSave_Click(object sender, EventArgs e)
{
int soDienMua = this.CheckNumber(txtSoDienMua);
decimal tienMua = this.CheckMoney(txtTienMua);
decimal thueMua = this.CheckMoney(txtThueMua);
int soDienBan = this.CheckNumber(txtSoDienBan);
decimal tienBan = this.CheckMoney(txtTienBan);
decimal thueBan = this.CheckMoney(txtThueBan);
decimal thuePhaiNop = this.CheckMoney(txtThuePhaiNop);
decimal thueDaNop = this.CheckMoney(txtThueDaNop);
decimal thueTNDN = this.CheckMoney(txtThueTNDN);
if (!this.HasError())
{
int result = 0;
if (actionMode == ActionMode.Add)
{
hhdvID = Guid.NewGuid();
result = this.tbl_TheoDoiHHDVTableAdapter.Insert(
dtpNgayGhiSo.Value,
soDienMua,
tienMua,
thueMua,
soDienBan,
tienBan,
thueBan,
thuePhaiNop,
thueDaNop,
thueTNDN,
string.Empty);
}
else if (actionMode == ActionMode.Edit)
{
result = DataTier.UpdateHHDV(
hhdvID,
dtpNgayGhiSo.Value,
soDienMua,
tienMua,
thueMua,
soDienBan,
tienBan,
thueBan,
thuePhaiNop,
thueDaNop,
thueTNDN) ? 1 : 0;
}
if (result > 0)
{
this.ClearForm();
this.tbl_TheoDoiHHDVTableAdapter.Fill(this.eMSDBDataSet.tbl_TheoDoiHHDV, int.Parse(cboYear.Text));
this.SelectRowByID(hhdvID.ToString());
this.dgvHHDV.Enabled = true;
this.btnCancel.Visible = false;
actionMode = ActionMode.Add;
}
else
{
MessageBox.Show(
"Lưu dữ liệu không thành công, bạn hãy thử lại sau.",
"Lưu dữ liệu không thành công",
MessageBoxButtons.OK,
MessageBoxIcon.Error);
}
}
}
public Rule(RulesPresenter i_dad,DataTier.Rules i_data)
{
Data = i_data;
Dad = i_dad;
}
private void xemBaoCaoForm_Load(object sender, EventArgs e)
{
if (reportType == "monthly")
{
this.Text = "EMS - Báo Cáo Điện " + monthlyReportType + " Tháng " + thang.ToString() + ", Năm " + nam.ToString() + ", Trạm Số " + soTram;
if (monthlyReportType == "Sinh Hoạt")
{
shReport = new MonthlyReport_SH();
shReport.SetDataSource(DataTier.fillMonthlyReport(tramID, thang, nam, 1));
string[] giaSH = DataTier.getPrice("e00f133e-f43c-4dc5-8ebb-a747200416c9").Split(',');
shReport.SetParameterValue("giaDienMuc1", giaSH[0]);
shReport.SetParameterValue("giaDienMuc2", giaSH[1]);
shReport.SetParameterValue("giaDienMuc3", giaSH[2]);
shReport.SetParameterValue("giaDienMuc4", giaSH[3]);
shReport.SetParameterValue("giaDienMuc5", giaSH[4]);
shReport.SetParameterValue("giaDienMuc6", giaSH[5]);
shReport.SetParameterValue("soTram", soTram);
shReport.SetParameterValue("ngayBatDau", DataTier.getDuration(tramID));
shReport.SetParameterValue("ngayKetThuc", DataTier.getDuration(tramID));
if (thang == 1)
{
shReport.SetParameterValue("thangBatDau", "12");
shReport.SetParameterValue("namBatDau", (nam - 1).ToString());
}
else
{
shReport.SetParameterValue("thangBatDau", (thang - 1).ToString());
shReport.SetParameterValue("namBatDau", nam.ToString());
}
shReport.SetParameterValue("thangKetThuc", thang.ToString());
shReport.SetParameterValue("namKetThuc", nam.ToString());
shReport.SetParameterValue("ngayKy", DataTier.getReportDate(tramID));
shReport.SetParameterValue("thangKy", thang.ToString());
shReport.SetParameterValue("namKy", nam.ToString());
double tongTien = DataTier.getTongTienPhatSinh(tramID, thang, nam, "1") + DataTier.getTongNo(tramID, thang, nam, "1");
shReport.SetParameterValue("moneyReader", Program.moneyReader(System.Math.Round(tongTien).ToString()));
crvReport.ReportSource = shReport;
}
else if (monthlyReportType == "Mục Đích Khác")
{
mdkReport = new MonthlyReport_MDK();
mdkReport.SetDataSource(DataTier.fillMonthlyReport(tramID, thang, nam, 0));
mdkReport.SetParameterValue("giaHC", DataTier.getPrice("068b5479-814c-4576-86ea-8684b07ffb4a"));
mdkReport.SetParameterValue("giaKD1", DataTier.getPrice("0cd8fc10-1369-4b21-9c59-806ada969bdb"));
mdkReport.SetParameterValue("giaKD2", DataTier.getPrice("3f4627cb-3ae3-4fcf-86e1-117b1dfcac4d"));
mdkReport.SetParameterValue("giaSX1", DataTier.getPrice("a8794644-b056-41dd-b515-bec60477947a"));
mdkReport.SetParameterValue("giaSX2", DataTier.getPrice("d4770373-51bb-4d7a-90d1-327c7043cdeb"));
mdkReport.SetParameterValue("gia30SX3", DataTier.getPrice("0cd8fc10-1369-4b21-9c59-806ada969bdb"));
mdkReport.SetParameterValue("gia70SX3", DataTier.getPrice("422cf080-b750-411d-a895-9550b8950b66"));
mdkReport.SetParameterValue("soTram", soTram);
mdkReport.SetParameterValue("ngayBatDau", DataTier.getDuration(tramID));
mdkReport.SetParameterValue("ngayKetThuc", DataTier.getDuration(tramID));
if (thang == 1)
{
mdkReport.SetParameterValue("thangBatDau", "12");
mdkReport.SetParameterValue("namBatDau", (nam - 1).ToString());
}
else
{
mdkReport.SetParameterValue("thangBatDau", (thang - 1).ToString());
mdkReport.SetParameterValue("namBatDau", nam.ToString());
}
mdkReport.SetParameterValue("thangKetThuc", thang.ToString());
mdkReport.SetParameterValue("namKetThuc", nam.ToString());
mdkReport.SetParameterValue("ngayKy", DataTier.getReportDate(tramID));
mdkReport.SetParameterValue("thangKy", thang.ToString());
mdkReport.SetParameterValue("namKy", nam.ToString());
double tongTien = DataTier.getTongTienPhatSinh(tramID, thang, nam, "0") + DataTier.getTongNo(tramID, thang, nam, "0");
mdkReport.SetParameterValue("moneyReader", Program.moneyReader(System.Math.Round(tongTien).ToString()));
crvReport.ReportSource = mdkReport;
}
}
else if (reportType == "tongHop")
{
this.Text = "EMS - Báo Cáo Tổng Hợp Tháng " + thang.ToString() + ", Năm " + nam.ToString() + ", Trạm Số " + soTram;
bcth = new TotalReport();
bcth.SetParameterValue("thang", thang.ToString());
bcth.SetParameterValue("nam", nam.ToString());
bcth.SetParameterValue("ngayKy", DataTier.getReportDate(tramID));
bcth.SetParameterValue("soTram", "Số " + soTram);
bcth.SetParameterValue("tongHoSH", soHoSH);
bcth.SetParameterValue("tongHoMDK", soHoMDK);
bcth.SetParameterValue("tongDienNhan", tongDienNhan);
bcth.SetParameterValue("dienSH", tongNhanSH);
bcth.SetParameterValue("dienMDK", tongNhanMDK);
bcth.SetParameterValue("tongThanhToan", tongTienThanhToan);
int tongDienThu = DataTier.getTongDienByMD(tramID, thang, nam, "all");
bcth.SetParameterValue("tongDienThu", tongDienThu);
bcth.SetParameterValue("dienThuSH", DataTier.getTongDienByMD(tramID, thang, nam, "e00f133e-f43c-4dc5-8ebb-a747200416c9"));
bcth.SetParameterValue("dienThuMDK", DataTier.getTongDienByMD(tramID, thang, nam, "0"));
double tyLeTonThat = tongDienNhan - tongDienThu;
tyLeTonThat = tyLeTonThat / tongDienNhan;
tyLeTonThat = tyLeTonThat * 100;
bcth.SetParameterValue("tyLeTonThat", tyLeTonThat.ToString("N2") + "%");
bcth.SetParameterValue("tienPhatSinh", DataTier.getTongTienPhatSinh(tramID, thang, nam, "all"));
bcth.SetParameterValue("tienNoCu", DataTier.getTongNo(tramID, thang, nam, "all"));
crvReport.ReportSource = bcth;
}
else if (reportType == "thuChi")
{
this.Text = "EMS - Báo Cáo Thu Chi";
}
else if (reportType == "theoDoiChuyenTien")
{
this.Text = "EMS - Bảng Theo Dõi Chuyển Tiền";
tdctReport = new TheoDoiChuyenTien();
tdctReport.SetDataSource(this.DataSource);
crvReport.ReportSource = tdctReport;
}
else if (reportType == "theoDoiHHDV")
{
this.Text = "EMS - Bảng Theo Dõi Hàng Hóa Dịch Vụ";
hhdvReport = new TheoDoiHHDV();
hhdvReport.SetDataSource(this.DataSource);
crvReport.ReportSource = hhdvReport;
}
else if (reportType == "theoDoiGTGT")
{
this.Text = "EMS - Bảng Theo Dõi Thuế GTGT";
gtgtReport = new TheoDoiGTGT();
gtgtReport.SetDataSource(this.DataSource);
crvReport.ReportSource = gtgtReport;
}
else if (reportType == "nhatKyChung")
{
this.Text = "EMS - Sổ Nhật Ký Chung";
nhatKyChungReport = new NhatKyChung();
nhatKyChungReport.SetDataSource(this.DataSource);
crvReport.ReportSource = nhatKyChungReport;
}
}
// Ian Bell - 10/13/2012
// Recieves dictionary with staffNo value.
// Checks:
// 1. The value isn't empty.
// 2. That the staffNo exists.
// 3. No foreign key constraints.
// Passes staffNo to data tier if it passes all tests
// returns table with appropriate error message if staffNo fails any test
public DataSet deleteStaff(Dictionary<String, String> staffNo)
{
DataSet ds = generateErrorDataSet();
String errorMessage = "";
try
{
DataTier dt = new DataTier();
if (staffNo["staffNo"].Length > 0)
{
if (staffNo["staffNo"].Length > 4)
errorMessage = "The maximum Staff Number is 4 characters.";
else if (dt.staffExists(staffNo).Tables[1].Rows[0][0].ToString() != "True")
errorMessage = "No Staff with that Staff Number exist.";
else if (dt.staffNumberConstraintExists(staffNo).Tables[1].Rows[0][0].ToString() == "True")
errorMessage = "You can't delete that Staff because they are listed under a Property for Rent.";
}
else
errorMessage = "You must enter a Staff Number.";
if (errorMessage.Length == 0)
dt.deleteStaff(staffNo);
if (errorMessage.Length > 0)
ds.Tables[0].Rows.Add(errorMessage);
}
catch (Exception ex)
{
logError(ex, "BusinessTier", "deleteStaff");
errorMessage = "We've encountered an unexpected difficulty. Please try again later or contact your administrator";
ds.Tables[0].Rows.Add(errorMessage);
}
return ds;
}
// Ian Bell - 10/16/2012
// Takes in Dictionary with staff number and returns a dataset with
// two tables. The first table has errors, and the second table has
// the values retrieved from DataTier
public DataSet getStaff(Dictionary<String, String> StaffNo)
{
DataSet ds = generateErrorDataSet();
String errorMessage = "";
try
{
DataTier dt = new DataTier();
if (StaffNo["staffID"].Length == 0)
errorMessage = "You must enter a Staff Number";
else if (StaffNo["staffID"].Length > 4)
errorMessage = "The maximum length of a Staff Number is 4 characters";
else
ds.Tables.Add(dt.lookupStaff(StaffNo["staffID"]).Tables[0].Copy());// added to existing table because the
// DataSet does not include the error table
// due to a flaw in how the contract was written
if(errorMessage.Length > 0)
ds.Tables[0].Rows.Add(errorMessage);
}
catch (Exception ex)
{
logError(ex, "BusinessTier", "getStaff");
ds.Tables[0].Rows.Add("An unexpected error occurred. Please try again later or contact support.");
}
return ds;
}
private void createInvoice()
{
try
{
string mucDichID = "";
string mucDichSD = "";
if (poorRadioButton.Checked)
{
mucDichID = "a770acf2-0f54-43ce-8695-10c7c4072c64";
mucDichSD = "Hộ nghèo";
}
else if (lowIncomeRadioButton.Checked)
{
mucDichID = "7e17ce3d-ea0c-4a6a-9048-47c563991fd6";
mucDichSD = "Hộ thu nhập thấp";
}
else if (sinhHoatRadioButton.Checked)
{
mucDichID = "e00f133e-f43c-4dc5-8ebb-a747200416c9";
mucDichSD = "Sinh hoạt";
}
else if (hanhChinhRadioButton.Checked)
{
mucDichID = "068b5479-814c-4576-86ea-8684b07ffb4a";
mucDichSD = "Hành chính";
}
else if (kinhDoanh1RadioButton.Checked)
{
mucDichID = "0cd8fc10-1369-4b21-9c59-806ada969bdb";
mucDichSD = "Kinh doanh 1";
}
else if (kinhDoanh2RadioButton.Checked)
{
mucDichID = "3f4627cb-3ae3-4fcf-86e1-117b1dfcac4d";
mucDichSD = "Kinh doanh 2";
}
else if (sanXuat1RadioButton.Checked)
{
mucDichID = "a8794644-b056-41dd-b515-bec60477947a";
mucDichSD = "Sản xuất 1";
}
else if (sanXuat2RadioButton.Checked)
{
mucDichID = "d4770373-51bb-4d7a-90d1-327c7043cdeb";
mucDichSD = "Sản xuất 2";
}
else if (sanXuat3RadioButton.Checked)
{
mucDichID = "422cf080-b750-411d-a895-9550b8950b66";
mucDichSD = "Sản xuất 3";
}
Customer kh = new Customer(soThuTuComboBox.SelectedValue.ToString(), tenKhachTextBox.Text, diaChiTextBox.Text, soHoKhauTextBox.Text, maSoThueTextBox.Text);
if (!kh.edit())
{
MessageBox.Show("Việc thay đổi thông tin của khách hàng đã thất bại!\nBạn hãy thử thay đổi thông tin khách hàng trong form khách hàng rồi quay lại làm lại hóa đơn.", "Lỗi", MessageBoxButtons.OK, MessageBoxIcon.Error, MessageBoxDefaultButton.Button1);
}
else
{
Invoice hoaDon;
if (congToChetCheckBox.Checked == true)
{
hoaDon = new Invoice(soThuTuComboBox.SelectedValue.ToString(), mucDichID, int.Parse(thangComboBox.Text), int.Parse(namComboBox.Text), int.Parse(soCuTextBox.Text), int.Parse(soMoiTextBox.Text), int.Parse(soCu2TextBox.Text), int.Parse(soMoi2TextBox.Text), int.Parse(heSoNhanTextBox.Text), int.Parse(noCuTextBox.Text), 0);
}
else
{
hoaDon = new Invoice(soThuTuComboBox.SelectedValue.ToString(), mucDichID, int.Parse(thangComboBox.Text), int.Parse(namComboBox.Text), int.Parse(soCuTextBox.Text), int.Parse(soMoiTextBox.Text), 0, 0, int.Parse(heSoNhanTextBox.Text), int.Parse(noCuTextBox.Text), 0);
}
Program.calculateInvoice(tramComboBox.Text.Split(' '), hoaDon.NewNumber, hoaDon.OldNumber, hoaDon.NewNumber2, hoaDon.OldNumber2, hoaDon.Multiplier, poorRadioButton.Checked, giaPoorLabel.Text, lowIncomeRadioButton.Checked, giaLowIncome.Text, sinhHoatRadioButton.Checked, DataTier.getPrice("e00f133e-f43c-4dc5-8ebb-a747200416c9").Split(','), hanhChinhRadioButton.Checked, giaHCLabel.Text, kinhDoanh1RadioButton.Checked, giaKD1Label.Text, kinhDoanh2RadioButton.Checked, giaKD2Label.Text, sanXuat1RadioButton.Checked, giaSX1Label.Text, sanXuat2RadioButton.Checked, giaSX2Label.Text, sanXuat3RadioButton.Checked, giaSX3Label.Text, thangComboBox.Text, namComboBox.Text, int.Parse(noCuTextBox.Text));
string title = "Hóa đơn của khách hàng số " + soThuTuComboBox.Text + ", " + tramComboBox.Text + ", tháng " + thangComboBox.Text + ", năm " + namComboBox.Text + ", mục đích " + mucDichSD;
if (mucDichSD == "Sinh hoạt")
{
Program.fillKetQuaSH(ketQuaSH);
ketQuaSH.Text = title;
dialogResult = ketQuaSH.ShowDialog();
}
else if (mucDichSD == "Sản xuất 3")
{
ketQuaSX3Form.mucDichSD = mucDichSD;
Program.fillKetQuaSX3(ketQuaSX3);
ketQuaSX3.Text = title;
dialogResult = ketQuaSX3.ShowDialog();
}
else
{
ketQuaMDKForm.mucDichSD = mucDichSD;
Program.fillKetQuaMDK(ketQuaMDK);
if (mucDichSD == "Hộ nghèo" || mucDichSD == "Hộ thu nhập thấp")
{
title = "Hóa đơn của khách hàng số " + soThuTuComboBox.Text + ", " + tramComboBox.Text + ", tháng " + thangComboBox.Text + ", năm " + namComboBox.Text + " (" + mucDichSD + ")";
}
ketQuaMDK.Text = title;
dialogResult = ketQuaMDK.ShowDialog();
}
if (dialogResult == DialogResult.OK)
{
if (hoaDon.createHoaDon())
{
var isOldInvoice = Program.isUsingOldInvoice();
ReportClass invoice = null;
if (sanXuat3RadioButton.Checked)
{
if (isOldInvoice)
{
invoice = new PrintInvoiceSX3();
invoice.PrintOptions.PaperSize = CrystalDecisions.Shared.PaperSize.PaperA4;
invoice.PrintOptions.PaperOrientation = CrystalDecisions.Shared.PaperOrientation.Portrait;
}
else
{
invoice = new PrintInvoiceSX3_201609();
invoice.PrintOptions.PaperSize = CrystalDecisions.Shared.PaperSize.PaperA5;
invoice.PrintOptions.PaperOrientation = CrystalDecisions.Shared.PaperOrientation.Landscape;
}
Program.setSX3InvoiceParams(hoaDon.getHoaDonID(), invoice);
try
{
if (mayInCheckBox.Checked)
{
invoice.PrintToPrinter(1, false, 1, 1);
//MessageBox.Show("Hóa đơn đã được in.", "In hóa đơn thành công", MessageBoxButtons.OK, MessageBoxIcon.Information, MessageBoxDefaultButton.Button1);
}
if (vanBanCheckBox.Checked)
{
string invoiceName = "HD Số thứ tự " + soThuTuComboBox.Text + " - " + tramComboBox.Text + " - Tháng " + thangComboBox.Text + " - Năm " + namComboBox.Text + ".doc";
invoice.ExportToDisk(CrystalDecisions.Shared.ExportFormatType.WordForWindows, pathTextBox.Text + "\\" + invoiceName);
//MessageBox.Show("Hóa đơn đã được xuất ra thư mục \"" + pathTextBox.Text + "\" \nvà có tên là \"" + invoiceName + "\"", "Xuất hóa đơn thành công", MessageBoxButtons.OK, MessageBoxIcon.Information, MessageBoxDefaultButton.Button1);
}
}
catch (Exception ex)
{
MessageBox.Show("Xuất hóa đơn thất bại: " + ex.Message, "Lỗi", MessageBoxButtons.OK, MessageBoxIcon.Error, MessageBoxDefaultButton.Button1);
}
invoice.Dispose();
}
else
{
if (isOldInvoice)
{
invoice = new PrintInvoice();
invoice.PrintOptions.PaperSize = CrystalDecisions.Shared.PaperSize.PaperA4;
invoice.PrintOptions.PaperOrientation = CrystalDecisions.Shared.PaperOrientation.Portrait;
}
else
{
invoice = new PrintInvoice_201609();
invoice.PrintOptions.PaperSize = CrystalDecisions.Shared.PaperSize.PaperA5;
invoice.PrintOptions.PaperOrientation = CrystalDecisions.Shared.PaperOrientation.Landscape;
}
Program.setInvoiceParams(hoaDon.getHoaDonID(), invoice);
try
{
if (mayInCheckBox.Checked)
{
invoice.PrintToPrinter(1, false, 1, 1);
//MessageBox.Show("Hóa đơn đã được in.", "In hóa đơn thành công", MessageBoxButtons.OK, MessageBoxIcon.Information, MessageBoxDefaultButton.Button1);
}
if (vanBanCheckBox.Checked)
{
string invoiceName = "HD Số thứ tự " + soThuTuComboBox.Text + " - " + tramComboBox.Text + " - Tháng " + thangComboBox.Text + " - Năm " + namComboBox.Text + ".doc";
invoice.ExportToDisk(CrystalDecisions.Shared.ExportFormatType.WordForWindows, pathTextBox.Text + "\\" + invoiceName);
//MessageBox.Show("Hóa đơn đã được xuất ra thư mục \"" + pathTextBox.Text + "\" \nvà có tên là \"" + invoiceName + "\"", "Xuất hóa đơn thành công", MessageBoxButtons.OK, MessageBoxIcon.Information, MessageBoxDefaultButton.Button1);
}
}
catch (Exception ex)
{
MessageBox.Show("Xuất hóa đơn thất bại: " + ex.Message, "Lỗi", MessageBoxButtons.OK, MessageBoxIcon.Error, MessageBoxDefaultButton.Button1);
}
invoice.Dispose();
}
}
else
{
MessageBox.Show("Xuất hóa đơn thất bại! Bạn hãy thử nhập lại.", "Lỗi", MessageBoxButtons.OK, MessageBoxIcon.Error, MessageBoxDefaultButton.Button1);
}
}
}
}
catch (Exception ex)
{
//MessageBox.Show("Xuất hóa đơn thất bại! Bạn hãy thử nhập lại.", "Lỗi", MessageBoxButtons.OK, MessageBoxIcon.Error, MessageBoxDefaultButton.Button1);
MessageBox.Show(ex.Message);
}
clearTextBoxes();
congToChetCheckBox.Checked = false;
fillSTTKH();
soMoiTextBox.Focus();
}
// Ian Bell - 10/13/2012
// Recieves dictionary with branch information values.
// Checks:
// 1. branch info doesn't exceed db field lengths
// 2. branchNo isn't empty
// 3. branchNo exists in db
// Passes staff info to data tier if it passes all tests
// returns table with appropriate error message if staff info fails any test
public DataSet updateBranch(Dictionary<String, String> updateBranchInfo)
{
DataSet ds = generateErrorDataSet();
String errorMessage = "";
try
{
DataTier dt = new DataTier();
errorMessage = checkBranchFieldLengths(updateBranchInfo);
if (errorMessage.Length == 0)// they entered a branchNo that doesn't exceed the field length
{
if (updateBranchInfo["branchNo"].Length > 0) // they entered a branchNo that doesn't exceed the field length
{
if (dt.branchExists(updateBranchInfo).Tables[1].Rows[0][0].ToString() != "True")
errorMessage = "No Branch with that Branch Number exists.";
}
else
errorMessage = "You must enter a Branch Number.";
}
if (errorMessage.Length == 0)
ds = dt.updateBranch(updateBranchInfo);
if (errorMessage.Length > 0)
ds.Tables[0].Rows.Add(errorMessage);
}
catch (Exception ex)
{
logError(ex, "BusinessTier", "updateBranch");
errorMessage = "We've encountered an unexpected difficulty. Please try again later or contact your administrator";
ds.Tables[0].Rows.Add(errorMessage);
}
return ds;
}
// Ian Bell - 10/13/2012
// Recieves dictionary with staff information values.
// Checks:
// 1. Staff info fields don't exceed db lengths
// 2. staffNo isn't empty.
// 3. staffNo exists.
// 4. salary is > $8,000 but < $100,000
// 5. DOB indicates staff is > 18 years old
// 6. If position == manager, that the branch doesn't already have a manager
// Passes staff info to data tier if it passes all tests
// returns table with appropriate error message if staff info fails any test
public DataSet updateStaff(Dictionary<String, String> updateStaffInfo)
{
DataSet ds = generateErrorDataSet();
String errorMessage = "";
String tempMessage = "";
try
{
DataTier dt = new DataTier();
errorMessage = checkStaffFieldLengths(updateStaffInfo);
// make sure staffNo doesn't exist
if (errorMessage.Length == 0)// ensure staffNo doesn't exceed the field length
{
if (updateStaffInfo["staffNo"].Length > 0)
{
if (dt.staffExists(updateStaffInfo).Tables[1].Rows[0][0].ToString() != "True")
errorMessage = "No Staff with that Staff Number exists.";
}
else
errorMessage = "You must enter a Staff Number.";
}
// make sure salary is within range
tempMessage = checkStaffSalary(updateStaffInfo["salary"]);
if(tempMessage.Length > 0)
errorMessage = tempMessage;
// make sure DOB is > than today - 18 years
tempMessage = checkStaffDOB(updateStaffInfo["DOB"]);
if (tempMessage.Length > 0)
errorMessage = tempMessage;
// if position == manager, make sure that branchNo doesn't have a manager
if (updateStaffInfo["position"] == "Manager")
if (updateStaffInfo["branchNo"].Length > 0) // if they entered a branchNo
if (dt.managerExists(updateStaffInfo).Tables[0].Rows[0][0].ToString() == "True")
errorMessage = "This Staff can't be a manager because that Branch already has a manager.";
if (errorMessage.Length == 0)
dt.updateStaff(updateStaffInfo);
if (errorMessage.Length > 0)
ds.Tables[0].Rows.Add(errorMessage);
}
catch (Exception ex)
{
logError(ex, "BusinessTier", "updateStaff");
errorMessage = "We've encountered an unexpected difficulty. Please try again later or contact your administrator";
ds.Tables[0].Rows.Add(errorMessage);
}
return ds;
}
private void m_category_selector_CategorySelected(DataTier.Categories i_selected)
{
Presenter.SelectCategory.Execute(i_selected);
m_expenses_selector.m_listbox.SelectedIndex++;
}
