public bool Reprint(string strMembershipID, User aUser, CardStatusType myType, string strCardBranchCode)
{
ACMSDAL.ConnectionProvider connProvider = new ConnectionProvider();
TblMember sqlMember = new TblMember();
TblCardRequest sqlCardRequest = new TblCardRequest();
TblAudit sqlAudit = new TblAudit();
bool isSuccess = false;
try
{
sqlMember.MainConnectionProvider = connProvider;
sqlCardRequest.MainConnectionProvider = connProvider;
sqlAudit.MainConnectionProvider = connProvider;
connProvider.OpenConnection();
connProvider.BeginTransaction("ReprintCard");
sqlMember.UpdateCardStatus(strMembershipID, (int)myType, strCardBranchCode);
sqlCardRequest.NEmployeeID = aUser.NEmployeeID();
sqlCardRequest.NStatusID = (int)myType;
sqlCardRequest.StrBranchCode = aUser.StrBranchCode();
sqlCardRequest.StrMembershipID = strMembershipID;
sqlCardRequest.DtLastEditDate = DateTime.Now;
sqlCardRequest.Insert();
sqlAudit.NAuditTypeID = ACMSLogic.AuditTypeID.MemberCard;
sqlAudit.NEmployeeID = aUser.NEmployeeID();
sqlAudit.StrAuditEntry = "Reprint member card.";
sqlAudit.StrReference = strMembershipID;
sqlAudit.DtDate = DateTime.Now;
sqlAudit.Insert();
connProvider.CommitTransaction();
isSuccess = true;
}
catch (Exception)
{
connProvider.RollbackTransaction("ReprintCard");
throw;
}
finally
{
if (connProvider.CurrentTransaction != null)
{
connProvider.CurrentTransaction.Dispose();
}
if (connProvider.DBConnection != null)
{
if (connProvider.DBConnection.State == ConnectionState.Open)
{
connProvider.DBConnection.Close();
}
connProvider.DBConnection.Dispose();
}
sqlMember.Dispose();
sqlCardRequest.Dispose();
sqlAudit.Dispose();
}
return(isSuccess);
}
public void initData(ACMSLogic.User User)
{
oUser = User;
MemberRecord myMemberRecord = new MemberRecord(oUser.StrBranchCode());
}
private void sbtnSave_Click(object sender, System.EventArgs e)
{
if (txtMemberName.Text.Length == 0)
{
UI.ShowErrorMessage(this, "Please fill in Member Name.");
txtMemberName.Focus();
DialogResult = DialogResult.None;
return;
}
if (txtNRICFIN.Text.Length == 0)
{
UI.ShowErrorMessage(this, "Please fill in NIRC/FIN.");
txtNRICFIN.Focus();
DialogResult = DialogResult.None;
return;
}
if (chkedtIsSg.Checked && !MemberRecord.ValidateNRICFormat(txtNRICFIN.Text))
{
if (UI.ShowYesNoMessage(this, "NIRC is not in valid format. Do you want enter again?", "Reminder"))
{
txtNRICFIN.Focus();
DialogResult = DialogResult.None;
return;
}
}
if (chkedtIsSg.Checked)
{
if (myMemberRecord.CheckDuplicateNRIC(txtNRICFIN.Text, "") > 0)
{
ACMS.Utils.UI.ShowErrorMessage(this, "This NRIC already registed by other person.", "Duplicate NRIC");
txtNRICFIN.Focus();
DialogResult = DialogResult.None;
return;
}
}
if (dateedtDOB.EditValue == null || dateedtDOB.EditValue.ToString().Length == 0)
{
ACMS.Utils.UI.ShowErrorMessage(this, "Please enter Date of Birth.");
dateedtDOB.Focus();
DialogResult = DialogResult.None;
return;
}
try
{
if (chkedtMember.Checked)
{
strMembershipID = myMemberRecord.AddNewMember(chkedtMember.Checked, strTerminalBranchCode, txtMemberName.Text, chkedtIsSg.Checked,
txtNRICFIN.Text, myUser.NEmployeeID(), dateedtDOB.DateTime, myUser);
}
else
{
strMembershipID = myMemberRecord.AddNewMember(chkedtMember.Checked, myUser.StrBranchCode(), txtMemberName.Text, chkedtIsSg.Checked,
txtNRICFIN.Text, myUser.NEmployeeID(), dateedtDOB.DateTime, myUser);
}
}
catch (Exception ex)
{
if (ex.InnerException.Message.IndexOf(
"Violation of PRIMARY KEY constraint 'PK_tblMember'. Cannot insert duplicate key in object 'tblMember") != -1)
{
UI.ShowErrorMessage("Duplicate ID found. Please reset membership ID.");
DialogResult = DialogResult.Cancel;
}
else
{
throw;
}
}
DialogResult = DialogResult.OK;
}
private void show_Class5()
{
ACMSLogic.User oUser = new User();
ReportPanel.Controls.Clear();
rptDayClass = new ACMS.ACMSManager.Reports.RPDayClassAnalysis(employee.Id,oUser.StrBranchCode());
rptDayClass.TopLevel = false;
rptDayClass.Dock = DockStyle.Fill;
rptDayClass.Parent = ReportPanel;
rptDayClass.Show();
ReportPanel.Refresh();
}
public string ConvertMember(DataRow rowMember, User aUser)
{
ACMSDAL.ConnectionProvider connProvider = new ConnectionProvider();
TblMember sqlMember = new TblMember();
TblBranch sqlBranch = new TblBranch();
TblAudit sqlAudit = new TblAudit();
TblCardRequest sqlCardRequest = new TblCardRequest();
try
{
sqlBranch.MainConnectionProvider = connProvider;
sqlMember.MainConnectionProvider = connProvider;
sqlAudit.MainConnectionProvider = connProvider;
sqlCardRequest.MainConnectionProvider = connProvider;
connProvider.OpenConnection();
connProvider.BeginTransaction("ConvertMember");
sqlBranch.StrBranchCode = aUser.StrBranchCode();
sqlBranch.IncOne();
string newMembershipID = aUser.StrBranchCode().TrimEnd() + sqlBranch.NMembershipNo;
sqlMember.StrBranchCode = aUser.StrBranchCode();
sqlMember.ConvertMember(rowMember["strMembershipID"].ToString(), newMembershipID);
sqlMember.ConvertMemberPurchase(rowMember["strMembershipID"].ToString(), newMembershipID);
sqlAudit.UpdateAllWstrReferenceLogic(newMembershipID, rowMember["strMembershipID"].ToString());
sqlAudit.NAuditTypeID = ACMSLogic.AuditTypeID.MemberRecord;
sqlAudit.NEmployeeID = aUser.NEmployeeID();
sqlAudit.StrAuditEntry = "Convert member from " + rowMember["strMembershipID"].ToString() + " to " + newMembershipID;
sqlAudit.StrReference = newMembershipID;
sqlAudit.DtDate = DateTime.Now;
sqlAudit.Insert();
//Request print for convert non member to member
//sqlCardRequest.NEmployeeID = aUser.NEmployeeID();
//sqlCardRequest.NStatusID = (int)CardStatusType.RequestPrint;
//sqlCardRequest.StrBranchCode = aUser.StrBranchCode();
//sqlCardRequest.StrMembershipID = newMembershipID;
//sqlCardRequest.DtLastEditDate = DateTime.Now;
//sqlCardRequest.Insert();
////Audit trail for request print
//sqlAudit.NAuditTypeID = ACMSLogic.AuditTypeID.MemberCard;
//sqlAudit.NEmployeeID = aUser.NEmployeeID();
//sqlAudit.StrAuditEntry = "New member card request when create convert member.";
//sqlAudit.StrReference = newMembershipID;
//sqlAudit.DtDate = DateTime.Now;
//sqlAudit.Insert();
connProvider.CommitTransaction();
return(newMembershipID);
}
catch (Exception)
{
connProvider.RollbackTransaction("ConvertMember");
throw;
}
finally
{
if (connProvider.CurrentTransaction != null)
{
connProvider.CurrentTransaction.Dispose();
}
if (connProvider.DBConnection != null)
{
if (connProvider.DBConnection.State == ConnectionState.Open)
{
connProvider.DBConnection.Close();
}
connProvider.DBConnection.Dispose();
}
sqlBranch.Dispose();
sqlMember.Dispose();
sqlAudit.Dispose();
sqlCardRequest.Dispose();
}
}
private void InitIPP()
{
oUser = new User();
ucMemberID1 = new ucMemberID();
ucMemberID1.StrBranchCode = oUser.StrBranchCode();
IPPdtStart.EditValue = DateTime.Today.Date;
IPPdtTo.EditValue = DateTime.Today.Date;
//string strSQL;
// myRP = new ACMSLogic.ReceiptPayment();
// gridReceipt.DataSource = myRP.SelectPresetTable;
DataTable dt = myCommon.ExecuteQuery("Select * from tblBank");
new ManagerBankLookupEditBuilder(dt, IPPBankCode.Properties);
new ManagerBankLookupEditBuilder(dt, lkBank.Properties);
dt = myCommon.ExecuteQuery("Select strBranchCode,strBranchName from tblBranch");
new ManagerBranchCodeLookupEditBuilder(dt, lkBranch.Properties);
}
private void show_Class2()
{
//ACMSLogic.User oUser = new User();
//ReportPanel.Controls.Clear();
//rptCAInstructor = new ACMS.ACMSManager.Reports.RPClassInstructor(employee.Id);
//rptCAInstructor.TopLevel = false;
//rptCAInstructor.Dock = DockStyle.Fill;
//rptCAInstructor.Parent = ReportPanel;
//rptCAInstructor.Show();
//ReportPanel.Refresh();
ACMSLogic.User oUser = new User();
ReportPanel.Controls.Clear();
rptCASchedule = new ACMS.ACMSManager.Reports.RPClassAnalysis(employee.Id, oUser.StrBranchCode());
rptCASchedule.TopLevel = false;
rptCASchedule.Dock = DockStyle.Fill;
rptCASchedule.Parent = ReportPanel;
rptCASchedule.Show();
ReportPanel.Refresh();
}
public bool Reprint(string strMembershipID, User aUser, CardStatusType myType, string strCardBranchCode)
{
ACMSDAL.ConnectionProvider connProvider = new ConnectionProvider();
TblMember sqlMember = new TblMember();
TblCardRequest sqlCardRequest = new TblCardRequest();
TblAudit sqlAudit = new TblAudit();
bool isSuccess = false;
try
{
sqlMember.MainConnectionProvider = connProvider;
sqlCardRequest.MainConnectionProvider = connProvider;
sqlAudit.MainConnectionProvider = connProvider;
connProvider.OpenConnection();
connProvider.BeginTransaction("ReprintCard");
sqlMember.UpdateCardStatus(strMembershipID, (int)myType, strCardBranchCode);
sqlCardRequest.NEmployeeID = aUser.NEmployeeID();
sqlCardRequest.NStatusID = (int)myType;
sqlCardRequest.StrBranchCode = aUser.StrBranchCode();
sqlCardRequest.StrMembershipID = strMembershipID;
sqlCardRequest.DtLastEditDate = DateTime.Now;
sqlCardRequest.Insert();
sqlAudit.NAuditTypeID = ACMSLogic.AuditTypeID.MemberCard;
sqlAudit.NEmployeeID = aUser.NEmployeeID();
sqlAudit.StrAuditEntry = "Reprint member card.";
sqlAudit.StrReference = strMembershipID;
sqlAudit.DtDate = DateTime.Now;
sqlAudit.Insert();
connProvider.CommitTransaction();
isSuccess = true;
}
catch (Exception)
{
connProvider.RollbackTransaction("ReprintCard");
throw;
}
finally
{
if (connProvider.CurrentTransaction != null)
connProvider.CurrentTransaction.Dispose();
if (connProvider.DBConnection != null)
{
if (connProvider.DBConnection.State == ConnectionState.Open)
connProvider.DBConnection.Close();
connProvider.DBConnection.Dispose();
}
sqlMember.Dispose();
sqlCardRequest.Dispose();
sqlAudit.Dispose();
}
return isSuccess;
}
public string ConvertMember(DataRow rowMember, User aUser)
{
ACMSDAL.ConnectionProvider connProvider = new ConnectionProvider();
TblMember sqlMember = new TblMember();
TblBranch sqlBranch = new TblBranch();
TblAudit sqlAudit = new TblAudit();
TblCardRequest sqlCardRequest = new TblCardRequest();
try
{
sqlBranch.MainConnectionProvider = connProvider;
sqlMember.MainConnectionProvider = connProvider;
sqlAudit.MainConnectionProvider = connProvider;
sqlCardRequest.MainConnectionProvider = connProvider;
connProvider.OpenConnection();
connProvider.BeginTransaction("ConvertMember");
sqlBranch.StrBranchCode = aUser.StrBranchCode();
sqlBranch.IncOne();
string newMembershipID = aUser.StrBranchCode().TrimEnd() +sqlBranch.NMembershipNo;
sqlMember.StrBranchCode = aUser.StrBranchCode();
sqlMember.ConvertMember(rowMember["strMembershipID"].ToString(), newMembershipID);
sqlMember.ConvertMemberPurchase(rowMember["strMembershipID"].ToString(), newMembershipID);
sqlAudit.UpdateAllWstrReferenceLogic(newMembershipID, rowMember["strMembershipID"].ToString());
sqlAudit.NAuditTypeID = ACMSLogic.AuditTypeID.MemberRecord;
sqlAudit.NEmployeeID = aUser.NEmployeeID();
sqlAudit.StrAuditEntry = "Convert member from " +rowMember["strMembershipID"].ToString() +" to " +newMembershipID;
sqlAudit.StrReference = newMembershipID;
sqlAudit.DtDate = DateTime.Now;
sqlAudit.Insert();
//Request print for convert non member to member
//sqlCardRequest.NEmployeeID = aUser.NEmployeeID();
//sqlCardRequest.NStatusID = (int)CardStatusType.RequestPrint;
//sqlCardRequest.StrBranchCode = aUser.StrBranchCode();
//sqlCardRequest.StrMembershipID = newMembershipID;
//sqlCardRequest.DtLastEditDate = DateTime.Now;
//sqlCardRequest.Insert();
////Audit trail for request print
//sqlAudit.NAuditTypeID = ACMSLogic.AuditTypeID.MemberCard;
//sqlAudit.NEmployeeID = aUser.NEmployeeID();
//sqlAudit.StrAuditEntry = "New member card request when create convert member.";
//sqlAudit.StrReference = newMembershipID;
//sqlAudit.DtDate = DateTime.Now;
//sqlAudit.Insert();
connProvider.CommitTransaction();
return newMembershipID;
}
catch (Exception)
{
connProvider.RollbackTransaction("ConvertMember");
throw;
}
finally
{
if (connProvider.CurrentTransaction != null)
connProvider.CurrentTransaction.Dispose();
if (connProvider.DBConnection != null)
{
if (connProvider.DBConnection.State == ConnectionState.Open)
connProvider.DBConnection.Close();
connProvider.DBConnection.Dispose();
}
sqlBranch.Dispose();
sqlMember.Dispose();
sqlAudit.Dispose();
sqlCardRequest.Dispose();
}
}
private void btnTransfer_Click(object sender, System.EventArgs e)
{
if (GridViewLocker.RowCount > 0)
{
DataRow dr = GridViewLocker.GetDataRow(this.GridViewLocker.FocusedRowHandle);
ACMSLogic.User oUser = new User();
myTMForm = new ACMS.ACMSBranch.BranchTransaction.frmTransferLocker(Convert.ToInt32(dr["nLockerNo"]),dr["strMembershipID"].ToString(),oUser.StrBranchCode());
myTMForm.initData(oUser);
myTMForm.ShowDialog();
myTMForm.Dispose();
initLockerMaintenance();
}
}
