private void Delete()
{
try
{
member = new BIZ.Member();
GetControlValue();
if (MemberID > 0)
{
if ((MessageBox.Show("Are you sure! You would like to delete this record?", "Confirm", MessageBoxButtons.YesNo) == DialogResult.Yes))
{
PopulateBusinessLayer(Common.Common.RingManagement.Member);
if (member.MemberRingDelete())
{
txtRingNumber.Text = "";
this.txtBandID.Text = "0";
txtRingNumber.Focus();
GetMemberRingEnrolled();
GetControlValue();
}
}
}
}
catch (Exception ex)
{
MessageBox.Show(Common.Common.CustomError(ex.Message), "Error");
}
}
private void DTMobileNumberList_DoubleClick(object sender, EventArgs e)
{
try
{
DataGridView datagrid = this.dataGridView1;
Int64 index;
if (datagrid.RowCount > 0)
{
member = new BIZ.Member();
index = datagrid.CurrentRow.Index;
string mobileNo = Convert.ToString(datagrid.Rows[Convert.ToInt32(index)].Cells[1].Value);
if (mobileNo != "")
{
if ((string)datagrid.CurrentCell.Value.ToString() == "UNREG")
{
if (MessageBox.Show("Do you want to unregister this mobile number?", "Unreg", MessageBoxButtons.YesNo) == DialogResult.Yes)
{
DataTable dtResult = member.UnregMobileNumber(ClubID.ToString(), mobileNo, UserID.ToString());
if (dtResult.Rows.Count > 0)
{
MessageBox.Show(dtResult.Rows[0][0].ToString(), "Unreg");
}
GetMobileNumberList();
}
}
}
}
}
catch (Exception ex)
{
MessageBox.Show(Common.Common.CustomError(ex.Message), "Error");
}
}
private void DTEntryList_DoubleClick(object sender, EventArgs e)
{
try
{
DataGridView datagrid = this.dtEntryList;
Int64 index;
if (datagrid.RowCount > 0)
{
member = new BIZ.Member();
index = datagrid.CurrentRow.Index;
EntryID = Convert.ToInt64(datagrid.Rows[Convert.ToInt32(index)].Cells[0].Value);
if (EntryID > 0)
{
MemberIDNo = datagrid.Rows[Convert.ToInt32(index)].Cells[1].Value.ToString();
BandID = (Int64)datagrid.Rows[Convert.ToInt32(index)].Cells[3].Value;
RingNumber = datagrid.Rows[Convert.ToInt32(index)].Cells[4].Value.ToString();
StickerCode = datagrid.Rows[Convert.ToInt32(index)].Cells[5].Value.ToString();
txtEntryBarcodeID.Text = Convert.ToString(datagrid.Rows[Convert.ToInt32(index)].Cells[6].Value);
PopulateControlValue("MemberDataFromGrid");
GetMemberDetails();
}
}
}
catch (Exception ex)
{
MessageBox.Show(Common.Common.CustomError(ex.Message), "Error");
}
}
private void MemberDetailsSelectAll()
{
member = new BIZ.Member();
PopulateBussinessLayer();
member.MemberDetailsSelectAll(this.dataGridView1);
this.lblRecordCount.Text = dataGridView1.Rows.Count.ToString();
}
private void EntryDelete()
{
try
{
member = new BIZ.Member();
GetControlValue();
if (EntryID > 0)
{
if ((MessageBox.Show("Are you sure! You would like to delete this record?", "Confirm", MessageBoxButtons.YesNo) == DialogResult.Yes))
{
PopulateBusinessLayer(Common.Common.RaceEntryClassType.Entry);
if (entry.EntryDelete())
{
this.txtEntryID.Text = "0";
this.txtRingNumber.Text = "";
this.txtStickerCode.Text = "";
this.txtEntryBarcodeID.Text = "";
this.BandID = 0;
this.txtRingNumber.Focus();
EntryListGetByRaceReleasePoint();
EntryListGetByMemberIDNo();
}
}
}
}
catch (Exception ex)
{
MessageBox.Show(Common.Common.CustomError(ex.Message), "Error");
}
}
private void GetMemberDetails()
{
try
{
member = new BIZ.Member();
GetControlValue();
PopulateBusinessLayer(Common.Common.RaceEntryClassType.Member);
MemberDetailsData = member.MemberDetailsSearchByKey().Tables[0];
if (MemberDetailsData.Rows.Count > 0)
{
PopulateControlValue("Member");
txtMemberIDNo.ReadOnly = true;
btnGO.Enabled = false;
button1.Enabled = true;
button5.Enabled = true;
GetMemberRingEnrolled();
EntryListGetByMemberIDNo();
this.txtRingNumber.Focus();
}
else
{
button1.Enabled = false;
button5.Enabled = false;
MessageBox.Show("No record found, Invalid Member ID", "No Record");
}
}
catch (Exception ex)
{
MessageBox.Show(Common.Common.CustomError(ex.Message), "Error");
}
}
private void button1_Click(object sender, EventArgs e)
{
try
{
BIZ.Member member = new BIZ.Member();
member.ReaderID = this.txtReaderID.Text;
member.ClubID = Convert.ToInt64(this.txtClubID.Text);
member.ClubName = this.cmbClub.Text;
member.Overwrite = false;
if (this.checkBox1.Checked)
{
member.Overwrite = true;
}
if (member.RFIDRegisterSave())
{
this.checkBox1.Checked = false;
txtReaderID.Text = "";
txtReaderID.Focus();
MessageBox.Show("RFID registration success.");
}
}
catch (Exception ex)
{
MessageBox.Show(Common.Common.CustomError(ex.Message), "Error");
}
}
private void EClockMasterListExport(String Drive)
{
DataTable dt = new DataTable();
BIZ.Member member = new BIZ.Member();
member.ClubID = ClubID;
dt = member.ExportEClockMasterlist();
this.progressBar1.Minimum = 0;
this.progressBar1.Maximum = dt.Rows.Count;
this.progressBar1.Step = 1;
this.progressBar1.Value = 0;
this.label1.Text = "Exporting Masterlist Data";
string path = Drive + @"Masterlist.inf";
string collection = "";
if (File.Exists(path))
{
File.Delete(path);
}
if (!File.Exists(path))
{
// Create a file to write to.
using (StreamWriter sw = File.CreateText(path))
{
foreach (DataRow item in dt.Rows)
{
collection = ClubID.ToString() + "|" + item["MemberID"].ToString() + "|" + item["MemberID No."].ToString() + "|" + item["Name"].ToString() + "|" + item["Coordinates"].ToString();
sw.WriteLine(Common.Common.Encrypt(collection));
System.Threading.Thread.Sleep(50);
this.progressBar1.PerformStep();
}
}
}
}
private void GetMemberRingEnrolled()
{
member = new BIZ.Member();
GetControlValue();
PopulateBusinessLayer(Common.Common.RingManagement.Member);
this.dataGridView1.DataSource = member.MemberRingSearchByKey();
this.dataGridView1.Columns[0].Visible = false;
}
private void Save()
{
try
{
member = new BIZ.Member();
if (this.rbIndividual.Checked)
{
GetControlValue();
PopulateBusinessLayer(Common.Common.RingManagement.Member);
if (member.MemberRingSave())
{
clearBandInfo();
this.txtRingNumber.Focus();
GetControlValue();
MessageBox.Show("Member Ring Record Save!", "Record Save");
}
}
else
{
if (Convert.ToInt32(txtRange1.Text) >= Convert.ToInt32(txtRange2.Text))
{
MessageBox.Show("Invalid Range.", "Error");
}
else if (this.txtBandFormat.Text == "")
{
MessageBox.Show("Band format is empty.", "Error");
}
else
{
for (int a = Convert.ToInt32(this.txtRange1.Text); a <= Convert.ToInt32(this.txtRange2.Text); a++)
{
this.txtRingNumber.Text = txtBandFormat.Text + a.ToString();
GetControlValue();
PopulateBusinessLayer(Common.Common.RingManagement.Member);
member.MemberRingSave();
}
clearBandInfo();
this.txtBandFormat.Focus();
GetControlValue();
MessageBox.Show("Member Ring Record Save!", "Record Save");
}
}
}
catch (Exception ex)
{
MessageBox.Show(Common.Common.CustomError(ex.Message), "Error");
clearBandInfo();
}
}
private void GetMemberDetails()
{
try
{
member = new BIZ.Member();
GetControlValue();
PopulateBusinessLayer(Common.Common.RaceEntryClassType.Member);
MemberDetailsData = member.GetMemberDistance();
PopulateControlValue(MemberDetailsData.Tables[0], MemberDetailsData.Tables[1], MemberDetailsData.Tables[2]);
}
catch (Exception ex)
{
MessageBox.Show(Common.Common.CustomError(ex.Message), "Error");
}
}
private void GetMemberDistancePerReleasePoint()
{
try
{
DataTable dtResult;
member = new BIZ.Member();
GetControlValue();
PopulateBussinessLayer(Common.Common.RaceScheduleDetails.Member);
dtResult = member.GetMembetDistancePerReleasePoint();
this.dtMemberList.DataSource = dtResult;
}
catch (Exception ex)
{
throw ex;
}
}
private void GetMemberDetails()
{
try
{
DataSet dt = new DataSet();
BIZ.Member member = new BIZ.Member();
member.ClubID = ClubID;
member.MemberIDNo = txtMemberIDNo.Text;
dt = member.GetMemberDistance();
PopulateControlValue(dt.Tables[0]);
}
catch (Exception ex)
{
MessageBox.Show(Common.Common.CustomError(ex.Message), "Error");
}
}
private void GetMobileNumberList()
{
try
{
member = new BIZ.Member();
DataTable dtResultSMS = new DataTable();
GetControlValue();
PopulateBussinessLayer();
dtResultSMS = member.MemberDetailsSearchByKey().Tables[1];
this.dataGridView1.DataSource = dtResultSMS;
}
catch (Exception ex)
{
throw ex;
}
}
private void MemberDetailDelete()
{
try
{
member = new BIZ.Member();
GetControlValue();
if (ID > 0)
{
if ((MessageBox.Show("Are you sure! You would like to delete this record?", "Confirm", MessageBoxButtons.YesNo) == DialogResult.Yes))
{
PopulateBussinessLayer();
if (member.MemberDetailsDelete())
{
this.Close();
}
}
}
}
catch (Exception ex)
{
MessageBox.Show(Common.Common.CustomError(ex.Message), "Error");
}
}
private void GetMemberDetails()
{
try
{
member = new BIZ.Member();
GetControlValue();
PopulateBusinessLayer(Common.Common.RingManagement.Member);
MemberDetailsData = member.MemberDetailsSearchByKey().Tables[0];
if (MemberDetailsData.Rows.Count > 0)
{
PopulateControlValue();
txtMemberIDNo.ReadOnly = true;
btnGO.Enabled = false;
}
else
{
MessageBox.Show("No record found, Invalid Member ID", "No Record");
}
}
catch (Exception ex)
{
MessageBox.Show(Common.Common.CustomError(ex.Message), "Error");
}
}
private void Save()
{
try
{
member = new BIZ.Member();
GetControlValue();
PopulateBussinessLayer();
var IsSave = member.Save();
if (IsSave && !IsEdit)
{
if (!IsDirect)
{
ClearControl();
this.txtMemberIDNo.Focus();
MessageBox.Show("Member Record Save!", "Record Save");
}
}
}
catch (Exception ex)
{
MessageBox.Show(Common.Common.CustomError(ex.Message), "Error");
}
}
private void DTMemberEntryList_DoubleClick(object sender, EventArgs e)
{
try
{
DataGridView datagrid = this.dtEntryMemberList;
Int64 index;
if (datagrid.RowCount > 0)
{
member = new BIZ.Member();
index = datagrid.CurrentRow.Index;
EntryID = Convert.ToInt64(datagrid.Rows[Convert.ToInt32(index)].Cells[0].Value);
if (EntryID > 0)
{
if ((string)datagrid.CurrentCell.Value.ToString() == "EDIT")
{
MemberIDNo = datagrid.Rows[Convert.ToInt32(index)].Cells[4].Value.ToString();
BandID = (Int64)datagrid.Rows[Convert.ToInt32(index)].Cells[6].Value;
RingNumber = datagrid.Rows[Convert.ToInt32(index)].Cells[7].Value.ToString();
StickerCode = datagrid.Rows[Convert.ToInt32(index)].Cells[8].Value.ToString();
txtEntryIdentity.Text = Convert.ToString(datagrid.Rows[Convert.ToInt32(index)].Cells[9].Value);
PopulateControlValue("MemberDataFromGrid");
GetMemberDetails();
}
else if ((string)datagrid.CurrentCell.Value.ToString() == " + ")
{
frmEntryMultipleCategory frmMultiplyCategory = new frmEntryMultipleCategory();
if (Convert.ToBoolean(datagrid.Rows[Convert.ToInt32(index)].Cells[3].Value))
{
string entrylist = "";
string bandlist = "";
foreach (DataGridViewRow item in datagrid.Rows)
{
if (Convert.ToBoolean(item.Cells[3].Value))
{
entrylist = entrylist == "" ? item.Cells[0].Value.ToString() : entrylist + "|" + item.Cells[0].Value.ToString();
bandlist = bandlist == "" ? item.Cells[7].Value.ToString() : bandlist + "|" + item.Cells[7].Value.ToString();
}
}
frmMultiplyCategory.EntryID = "0";
frmMultiplyCategory.BandNumberList = bandlist;
frmMultiplyCategory.EntryList = entrylist;
}
else
{
frmMultiplyCategory.BandNumber = datagrid.Rows[Convert.ToInt32(index)].Cells[7].Value.ToString();
frmMultiplyCategory.StickerCode = datagrid.Rows[Convert.ToInt32(index)].Cells[8].Value.ToString();
frmMultiplyCategory.EntryID = datagrid.Rows[Convert.ToInt32(index)].Cells[0].Value.ToString();
frmMultiplyCategory.OrigCategory = datagrid.Rows[Convert.ToInt32(index)].Cells[11].Value.ToString();
frmMultiplyCategory.MemberID = txtMemberID.Text;
}
frmMultiplyCategory.ClubID = ClubID;
frmMultiplyCategory.MemberID = txtMemberID.Text;
frmMultiplyCategory.ShowDialog();
EntryListGetByMemberIDNo();
}
else if ((string)datagrid.CurrentCell.Value.ToString() == "DELETE")
{
txtEntryID.Text = EntryID.ToString();
EntryDelete();
}
}
}
}
catch (Exception ex)
{
MessageBox.Show(Common.Common.CustomError(ex.Message), "Error");
}
}
private void grid_DoubleClick(object sender, EventArgs e)
{
try
{
DataGridView datagrid = this.dataGridView1;
Int64 index;
if (datagrid.RowCount > 0)
{
member = new BIZ.Member();
index = datagrid.CurrentRow.Index;
if ((string)datagrid.CurrentCell.Value.ToString() == "EDIT")
{
ID = Convert.ToString(datagrid.Rows[Convert.ToInt32(index)].Cells[0].Value);
if (Convert.ToInt64(ID) > 0)
{
DataTable dtresult = new DataTable();
DataTable dtResultSMS = new DataTable();
PopulateBussinessLayer();
dtresult = member.MemberDetailsSearchByKey().Tables[0];
dtResultSMS = member.MemberDetailsSearchByKey().Tables[1];
if (dtresult.Rows.Count > 0)
{
frmMemberDataEntry memberDataentry = new frmMemberDataEntry();
memberDataentry.ClubID = ClubID;
memberDataentry.UserID = UserID;
memberDataentry.RecordSearched = dtresult;
memberDataentry.RecordSearchedSMS = dtResultSMS;
memberDataentry.IsEdit = true;
memberDataentry.PopulateControl();
memberDataentry.ShowDialog();
MemberDetailsSelectAll(); //Refresh value of data grid
}
else
{
MessageBox.Show("No record is found", "Search");
}
}
}
else if ((string)datagrid.CurrentCell.Value.ToString() == "SELECT")
{
ID = Convert.ToString(datagrid.Rows[Convert.ToInt32(index)].Cells[0].Value);
if (Convert.ToInt64(ID) > 0)
{
DataTable dtresult = new DataTable();
DataTable dtResultSMS = new DataTable();
PopulateBussinessLayer();
dtresult = member.MemberDetailsSearchByKey().Tables[0];
//dtResultSMS = member.MemberDetailsSearchByKey().Tables[1];
if (dtresult.Rows.Count > 0)
{
MemberID = txtID.Text = dtresult.Rows[0]["ID"].ToString();
MemberIDNo = dtresult.Rows[0]["MemberIDNo"].ToString();
this.Close();
}
}
}
}
}
catch (Exception ex)
{
MessageBox.Show(Common.Common.CustomError(ex.Message), "Error");
}
}
private void WriteResultInSDCard()
{
try
{
DriveInfo driveInfo = Common.Common.GetEclockSDCardDriveInfo();
if (driveInfo != null)
{
DirectoryInfo di = new DirectoryInfo(driveInfo.RootDirectory.ToString());
DirectoryInfo[] directoryList = di.GetDirectories();
foreach (DirectoryInfo item in directoryList)
{
if (item.Name == "ECLOCK")
{
BIZ.Member member = new BIZ.Member();
member.Name = this.txtAssignedTo.Text;
member.ReaderID = this.txtReaderID.Text;
member.ClubID = Convert.ToInt64(this.txtClubID.Text);
member.ClubName = this.cmbClub.Text;
member.Type = "Player";
if (rdbClub.Checked)
{
member.Type = "Club";
}
if (member.ReaderRegistrationSave())
{
//application race result summary file
string systemConfig = item.Root + item.Name + "\\SystemConfig.inf";
if (!File.Exists(systemConfig))
{
File.Create(systemConfig).Close();
}
//clear club info File
File.WriteAllText(systemConfig, String.Empty);
using (System.IO.StreamWriter file = new System.IO.StreamWriter(systemConfig, true))
{
file.WriteLine("Electronic Bundy Clock");
file.WriteLine("Version 1.0");
file.WriteLine(this.cmbClub.Text);
if (rdbClub.Checked)
{
file.WriteLine("Application Administrator");
file.WriteLine(txtClubAbbreviation.Text);
file.WriteLine(txtClubID.Text);
}
else
{
file.WriteLine("Application Member");
}
file.WriteLine(txtReaderID.Text);
file.WriteLine(txtAssignedTo.Text);
file.WriteLine("SMS Not Activated");
};
this.txtReaderID.Text = "";
this.txtAssignedTo.Text = "";
this.txtReaderID.Focus();
if (rdbClub.Checked)
{
this.cmbClub.SelectedIndex = -1;
this.txtClubID.Text = "0";
this.txtClubAbbreviation.Text = "";
this.rdbPlayer.Checked = true;
}
MessageBox.Show("Reader registration success.");
}
}
}
}
}
catch (Exception ex)
{
throw ex;
}
}
