private void FrmMembers_Load(object sender, EventArgs e)
{
try
{
txtCode.Focus();
// TODO: TO MAKE THE PANEL IN THE CENTER OF THE WINDOW
Panel1.Left = (this.Width - Panel1.Width) / 2;
Panel1.Top = (this.Height - Panel1.Height) / 2;
// TODO: TO GET ALL THE MEMBERS
DAO.MemberDAO memberDAO = new DAO.MemberDAO();
DataSet ds = memberDAO.getAllMembersWithDataSet();
DataSet da = new DAO.MemberTypeDAO().GetAllMemberTypes();
cbMemberType.DataSource = da.Tables[0];
cbMemberType.DisplayMember = "membertypename";
cbMemberType.ValueMember = "membertypeid";
// TODO: TO BIND DATASET TO THE DataGridView
dgvMember.DataSource = ds.Tables[0];
dgvMember.Columns[8].Visible = false;
dgvMember.Columns[9].Visible = false;
dgvMember.Columns[10].Visible = false;
// TODO: TO SET THE COLUMN NAME OF THE DataGridView
Utility.setGridHeaderText("ល.រ|លេខកូដ|ឈ្មោះ|ទូរសព្ទ័|អត្រាភាគរយ|កាលបរិច្ជេទចាប់ផ្តើម|ដោយ|ប្រភេទសមាជិក", dgvMember);
// TODO: TO SET THE WIDTH SIZE OF THE DataGridView
Utility.setGridHeaderWidth("50|70|100|170|150|180|150|200", dgvMember);
}
catch (Exception ex)
{
Console.WriteLine(ex.ToString());
}
}
public FrmReport()
{
InitializeComponent();
productDAO = new DAO.ProductDAO();
invoiceDAO = new DAO.InvoiceDAO();
transactionDAO = new DAO.TransactionDAO();
memberDAO = new DAO.MemberDAO();
staffDAO = new DAO.StaffDAO();
DataSet ds = new DAO.StaffDAO().GetAllStaffs();
//DataRow dr = new DataRow("SELECT");
//ds.Tables[0].Rows.InsertAt(,0);
cboStaffs.DataSource = ds.Tables[0];
cboStaffs.DisplayMember = "staffname";
cboStaffs.ValueMember = "staffid";
//cboMember.Items.Insert(0, "-Select-");
}
private void cboMember_SelectedIndexChanged(object sender, EventArgs e)
{
if (cboMember.SelectedIndex != 0)
{
int memberid = (int)cboMember.SelectedValue;
DTO.Member member = new DAO.MemberDAO().getMemberById(memberid);
txtDiscount.Text = member.Discountrate + " %";
}
else
{
txtDiscount.Text = "0.00 %";
}
calculate();
}
private void FrmFrontSaleOffice_Load(object sender, EventArgs e)
{
DataSet ds = new DAO.MemberDAO().getAllMembersWithDataSet();
//DataRow dr = new DataRow("SELECT");
//ds.Tables[0].Rows.InsertAt(,0);
cboMember.DataSource = ds.Tables[0];
cboMember.DisplayMember = "membername";
cboMember.ValueMember = "memberid";
//cboMember.Items.Insert(0, "-Select-");
}
private void cboMember_SelectedIndexChanged(object sender, EventArgs e)
{
DTO.Member member = new DAO.MemberDAO().getMemberById(int.Parse(cboMember.SelectedValue.ToString()));
txtDiscount.Text = member.Discountrate.ToString();
}
private void FrmSale_Load(object sender, EventArgs e)
{
txtCode.Focus();
List<DTO.Member> members = new DAO.MemberDAO().getAllMembers();
cboMember.DataSource = members;
cboMember.DisplayMember = "membername";
cboMember.ValueMember = "memberid";
}
