private void BindingBooking() { DateTime curDate = SqlDb.ExecuteScalar <DateTime>("SELECT GETDATE()"); DataSet dsBookging = SqlDb.GetDataSet("SELECT PK, patientName, RegNo, (tblTitle.TitleName + ' ' + tblDoctor.doctor) As doctorName, " + "abdate, tokenNo, abTime, abType, isVisited, isNew, (tblBooking.doctorPK) As doctorPK FROM tblDoctor INNER JOIN tblBooking ON tblDoctor.doctorPK = tblBooking.doctorPK INNER JOIN tblTitle " + "ON tblDoctor.titlePK = tblTitle.titlePK WHERE tblBooking.isVisited = 0 AND abdate > @abDate", new MySqlParameter("@abDate", curDate.ToString("yyyy-MM-dd"))); grdBooking.DataSource = dsBookging.Tables[0]; grdViewBooking.FocusedRowHandle = curBookingIndex; }
private void cmdSave_Click(object sender, EventArgs e) { if (cboDoctor.Text.Length > 0 && grdViewClinicTime.RowCount > 0) { cmdSave.Focus(); for (int i = 0; i < grdViewClinicTime.RowCount; i++) { if (grdViewClinicTime.GetRowCellDisplayText(i, "fromTime").ToString().Length > 0 && grdViewClinicTime.GetRowCellDisplayText(i, "toTime").ToString().Length > 0 && cboDay.Text.Length > 0) { int timeCnt = SqlDb.ExecuteScalar <int>("SELECT COUNT(*) FROM tblClinicTimeByDoctor WHERE doctorPK = @DoctorPK AND ctdPK = @CTDPK", new MySqlParameter("@DoctorPK", (grdViewClinicTime.GetRowCellDisplayText(i, "doctorPK") != null) ? grdViewClinicTime.GetRowCellDisplayText(i, "doctorPK") : "0"), new MySqlParameter("@CTDPK", (grdViewClinicTime.GetRowCellDisplayText(i, "ctdPK") != null) ? grdViewClinicTime.GetRowCellDisplayText(i, "ctdPK") : "0")); if (timeCnt > 0) { SqlDb.ExecuteQuery("UPDATE tblClinicTimeByDoctor SET ctdPK=@CTDPK, doctorPK=@DoctorPK, clinicDay=@ClinicDay, ctdOption=@CTDOption, fromTime=@FromTime, " + "toTime=@ToTime, updatePK=@UpdatePK, updateDate=NOW() WHERE ctdPK = @CTDPK AND doctorPK = @DoctorPK", new MySqlParameter("@CTDPK", grdViewClinicTime.GetRowCellDisplayText(i, "ctdPK").ToString()), new MySqlParameter("@doctorPK", grdViewClinicTime.GetRowCellDisplayText(i, "doctorPK").ToString()), new MySqlParameter("@ClinicDay", cboDay.Text), new MySqlParameter("@CTDOption", grdViewClinicTime.GetRowCellDisplayText(i, "ctdOption").ToString()), new MySqlParameter("@FromTime", grdViewClinicTime.GetRowCellDisplayText(i, "fromTime").ToString()), new MySqlParameter("@ToTime", grdViewClinicTime.GetRowCellDisplayText(i, "toTime").ToString()), new MySqlParameter("@UpdatePK", AppVariable.CURRENT_USER_PK)); } else { int CTDPK = SqlDb.ExecuteScalar <int>("Call getID ('tblClinicTimeByDoctor')"); SqlDb.ExecuteQuery("INSERT INTO tblClinicTimeByDoctor(ctdPK, doctorPK, clinicDay, ctdOption, fromTime, toTime, createPK, createDate)" + "VALUES(@CTDPK, @DoctorPK, @ClinicDay, @CTDOption, @FromTime, @ToTime, @CreatePK, NOW())", new MySqlParameter("@CTDPK", CTDPK), new MySqlParameter("@doctorPK", cboDoctor.SelectedValue), new MySqlParameter("@ClinicDay", cboDay.Text), new MySqlParameter("@CTDOption", grdViewClinicTime.GetRowCellDisplayText(i, "ctdOption").ToString()), new MySqlParameter("@FromTime", grdViewClinicTime.GetRowCellDisplayText(i, "fromTime").ToString()), new MySqlParameter("@ToTime", grdViewClinicTime.GetRowCellDisplayText(i, "toTime").ToString()), new MySqlParameter("@CreatePK", AppVariable.CURRENT_USER_PK)); } } } MessageBox.Show("Save is successful.", "MediPro :: Clinic System", MessageBoxButtons.OK, MessageBoxIcon.Information); sysLogs.logsDetail(int.Parse(AppVariable.CURRENT_SUB_MENU.ToString()), "Update Clinic Time."); CTDBinding(); } }
private void BindingVisiting() { DateTime curDate = SqlDb.ExecuteScalar <DateTime>("SELECT GETDATE()"); int curDoctorPK = SqlDb.ExecuteScalar <int>("SELECT doctorPK FROM tblDoctor WHERE userPK = @UserPK", new MySqlParameter("@UserPK", AppVariable.CURRENT_USER_PK)); DataSet dsVisiting = SqlDb.GetDataSet("SELECT PK, patientName, RegNo, (tblTitle.TitleName + ' ' + tblDoctor.doctor) As doctorName, " + "abdate, tokenNo, abTime, abType, isVisited, isNew, (tblBooking.doctorPK) As doctorPK, visitPK FROM tblDoctor INNER JOIN tblBooking ON tblDoctor.doctorPK = tblBooking.doctorPK INNER JOIN tblTitle " + "ON tblDoctor.titlePK = tblTitle.titlePK WHERE abdate = @abDate AND tblBooking.doctorPK=@DoctorPK", new MySqlParameter("@abDate", curDate.ToString("yyyy-MM-dd")), new MySqlParameter("@DoctorPK", curDoctorPK)); grdTodayVisitPatients.DataSource = dsVisiting.Tables[0]; }
private void cmdSave_Click(object sender, EventArgs e) { if (ValidateForm() == true) { int UserCnt = SqlDb.ExecuteScalar <int>("SELECT COUNT(*) FROM sysUser WHERE PK = @PK AND passw = @PWD AND isDelete = 0", new MySqlParameter("@PK", AppVariable.CURRENT_USER_PK), new MySqlParameter("@PWD", Crypto.Encrypt(txtCurPassw.Text.Trim()))); if (UserCnt < 1) { MessageBox.Show("Your Current Password is not much.", "Error Message", MessageBoxButtons.OK, MessageBoxIcon.Error); txtCurPassw.Focus(); txtCurPassw.Select(0, txtCurPassw.Text.Length); } else { SqlDb.ExecuteQuery("UPDATE sysUser SET passw=@PWD,updatePK=@updatePK,updateDate=NOW() WHERE PK=@PK", new MySqlParameter("@PK", AppVariable.CURRENT_USER_PK), new MySqlParameter("@updatePK", AppVariable.CURRENT_USER_PK), new MySqlParameter("@PWD", Crypto.Encrypt(txtNewPassw.Text.Trim()))); sysLogs.logsDetail(1, "Change Password."); MessageBox.Show("Update is successful.", "MediPro :: Clinic System", MessageBoxButtons.OK, MessageBoxIcon.Information); } } }
private void cmdLogin_Click(object sender, EventArgs e) { if (loginCnt == 3) { Application.ExitThread(); } else if (ValidateForm() == true) { //string Login = SqlDb.ExecuteScalar<string>("SELECT login FROM sysUser WHERE login=@Login AND passw=@PWD AND levelPK=@LevelPK AND isDelete=@isDelete AND isActive=@isActive", // new MySqlParameter("@login", txtLogin.Text.Trim()), // new MySqlParameter("@PWD", Crypto.Encrypt(txtPassword.Text.Trim())), // new MySqlParameter("@LevelPK", cboUserLevel.SelectedValue), // new MySqlParameter("@isDelete", false), // new MySqlParameter("@isActive", true)); string Login = SqlDb.ExecuteScalar <string>("SELECT login FROM sysUser WHERE login=@Login AND passw=@PWD AND isDelete=@isDelete AND isActive=@isActive", new MySqlParameter("@login", txtLogin.Text.Trim()), new MySqlParameter("@PWD", Crypto.Encrypt(txtPassword.Text.Trim())), new MySqlParameter("@isDelete", false), new MySqlParameter("@isActive", true)); int AuthCnt = (Login == txtLogin.Text.Trim()) ? 1 : 0; if (AuthCnt > 0) { DataSet dsUser = SqlDb.GetDataSet("SELECT PK, name, login, levelPK, branchPK FROM sysUser WHERE login=@Login AND passw=@PWD AND isDelete=@isDelete AND isActive=@isActive", new MySqlParameter("@login", txtLogin.Text.Trim()), new MySqlParameter("@PWD", Crypto.Encrypt(txtPassword.Text.Trim())), new MySqlParameter("@isDelete", false), new MySqlParameter("@isActive", true)); AppVariable.CURRENT_USER_PK = int.Parse(dsUser.Tables[0].Rows[0]["PK"].ToString()); AppVariable.CURRENT_USER_FULLNAME = dsUser.Tables[0].Rows[0]["name"].ToString(); AppVariable.CURRENT_USER_LEVEL_ID = int.Parse(dsUser.Tables[0].Rows[0]["levelPK"].ToString()); AppVariable.CURRENT_LOGIN_ID = dsUser.Tables[0].Rows[0]["login"].ToString(); AppVariable.CURRENT_BRANCH_PK = int.Parse(dsUser.Tables[0].Rows[0]["branchPK"].ToString()); sysLogs.logs_login(); //new frmLabInvoice().Show(); //return; Main MainForm = new Main(); MainForm.Show(); this.Hide(); } else { loginCnt = loginCnt++; MessageBox.Show("Your Login Information is not valid. Please try again.", "MediPro :: Clinic System", MessageBoxButtons.OK, MessageBoxIcon.Error); txtLogin.Focus(); } } }
private void cmdSave_Click(object sender, EventArgs e) { if (ValidateForm() == true) { int UserCnt = SqlDb.ExecuteScalar <int>("SELECT COUNT(*) FROM sysUser WHERE PK = @PK AND isDelete =0", new MySqlParameter("@PK", txtNewPassw.Tag.ToString())); if (UserCnt > 0 && cmdSave.Tag.ToString() == "Edit") { SqlDb.ExecuteQuery("UPDATE sysUser SET passw=@Passw,updatePK,updateDate=NOW() WHERE PK=@UserID", new MySqlParameter("@UserID", txtNewPassw.Tag.ToString()), new MySqlParameter("@updatePK", AppVariable.CURRENT_USER_PK), new MySqlParameter("@Passw", Crypto.Encrypt(txtNewPassw.Text.Trim()))); sysLogs.logsDetail(int.Parse(AppVariable.CURRENT_SUB_MENU.ToString()), "Reset Password."); MessageBox.Show("Update is successful.", "MediPro :: Clinic System", MessageBoxButtons.OK, MessageBoxIcon.Information); } } }
public static void Save(string labTestPricePK, string labTestPK, string branchPK, double originalPrice, double profitMargin, int exchangePK, double discount, double sellingPrice) { clsSQL sql = new clsSQL(); bool isExisted = false; isExisted = sql.ExecuteScalar<Int32>("Select Count(*) from tblLabTestPrice where labTestPricePK=@PK", new MySqlParameter("@PK", labTestPricePK)) > 0 ? true : false; if (!isExisted) { //Insert labTestPricePK = Guid.NewGuid().ToString(); sql.ExecuteNonQuery("Insert into tblLabTestPrice(labTestPricePK,labTestPK,branchPK,originalPrice,ProfitMargin,exchangePK,discount,sellingPrice,createPK,createDate,updatePK,updateDate) values(" + "@labTestPricePK,@labTestPK,@branchPK,@originalPrice,@ProfitMargin,@exchangePK,@discount,@sellingPrice,@createPK,@createDate,@updatePK,@updateDate)", new MySqlParameter("labTestPricePK", labTestPK), new MySqlParameter("@labTestPK", labTestPK), new MySqlParameter("@branchPK", branchPK), new MySqlParameter("@originalPrice", originalPrice), new MySqlParameter("@ProfitMargin", profitMargin), new MySqlParameter("@exchangePK", exchangePK), new MySqlParameter("@discount", discount), new MySqlParameter("@sellingPrice", sellingPrice), new MySqlParameter("@createPK", "1"), new MySqlParameter("@createDate", DateTime.Now), new MySqlParameter("@updatePK", "1"), new MySqlParameter("@updateDate", DateTime.Now)); } else { //Update sql.ExecuteNonQuery("Update tblLabTestPrice set labTestPricePK=@labTestPricePK,labTestPK=@labTestPK,branchPK=@branchPK,originalPrice=@originalPrice,ProfitMargin=@ProfitMargin,exchangePK=@exchangePK,discount=@discount,sellingPrice=@sellingPrice," + "updatePK=@updatePK,updateDate=@updateDate where labTestPricePK=@labTestPricePK", new MySqlParameter("labTestPricePK", labTestPricePK), new MySqlParameter("@labTestPK", labTestPK), new MySqlParameter("@branchPK", branchPK), new MySqlParameter("@originalPrice", originalPrice), new MySqlParameter("@ProfitMargin", profitMargin), new MySqlParameter("@exchangePK", exchangePK), new MySqlParameter("@discount", discount), new MySqlParameter("@sellingPrice", sellingPrice), new MySqlParameter("@updatePK", "1"), new MySqlParameter("@updateDate", DateTime.Now)); } }
private void cmdSave_Click(object sender, EventArgs e) { if (ValidateForm() == true) { int Cnt = SqlDb.ExecuteScalar <int>("SELECT COUNT(*) FROM tblLabSubTest WHERE labSubTestName=@LabSubTestName AND isDelete=0 AND labSubTestPK<>@labSubTestPK", new MySqlParameter("@LabSubTestName", txtCode.Text.Trim()), new MySqlParameter("@labSubTestPK", txtCode.Tag.ToString())); if (Cnt > 0) { MessageBox.Show("Your Lab Sub Test Name is already exit. Please check your Lab Sub Test Name.", "MediPro :: Clinic System", MessageBoxButtons.OK, MessageBoxIcon.Error); txtCode.Focus(); txtCode.SelectAll(); } else { if (txtCode.Tag.ToString().Length > 0) { int LabIDCnt = SqlDb.ExecuteScalar <int>("SELECT COUNT(*) FROM tblLabSubTest WHERE labSubTestPK=@labSubTestPK AND isDelete=0", new MySqlParameter("@labSubTestPK", txtCode.Tag.ToString())); if (LabIDCnt > 0) { SqlDb.ExecuteQuery("UPDATE tblLabSubTest SET labTestPK=@labTestPK, labSubTestCode=@labSubTestCode, labSubTestName=@LabSubTestName,labSubTestDescription=@labSubTestDescription,specimen=@specimen,information=@information,reference=@reference,tat=@tat,method=@method,daysSetup=@daysSetup,clinicalUsage=@clinicalUsage," + "isActive=@IsActive,updateDate=NOW(),updatePK=@UpdatePK WHERE labSubTestPK=@labSubTestPK", new MySqlParameter("@labTestPK", cboLabTest.SelectedValue), new MySqlParameter("@labSubTestPK", int.Parse(txtCode.Tag.ToString())), new MySqlParameter("@labSubTestCode", txtCode.Text.Trim()), new MySqlParameter("@labSubTestName", txtName.Text.Trim()), new MySqlParameter("@labSubTestDescription", txtDescription.Text.Trim()), new MySqlParameter("@specimen", txtSpecimen.Text.Trim()), new MySqlParameter("@information", txtInfo.Text.Trim()), new MySqlParameter("@reference", txtRef.Text.Trim()), new MySqlParameter("@tat", txtTat.Text.Trim()), new MySqlParameter("@method", txtMethod.Text.Trim()), new MySqlParameter("@daysSetup", txtDays.Text.Trim()), new MySqlParameter("@clinicalUsage", txtUsage.Text.Trim()), new MySqlParameter("@IsActive", chkIsActive.EditValue), new MySqlParameter("@updatePK", AppVariable.CURRENT_USER_PK.ToString())); //SqlDb.ExecuteNonQuery("Delete from tblLabTestDetail where labTestPK=@labTestPK", new MySqlParameter("@labTestPK", txtCode.Tag)); //if (isDetailExist()) //{ // int pk = SqlDb.ExecuteScalar<int>("getid tblLabTestDetail"); // SqlDb.ExecuteQuery("INSERT INTO tblLabTestDetail(labTestDetailPK,labTestPK, specimen,information,reference,tat,method,daysSetup,clinicalUsage, isActive,updateDate,updatePK,createDate,createPK) " + // "VALUES(@labTestDetailPK,@labTestPK,@specimen,@information,@reference,@tat,@method,@daysSetup,@clinicalUsage,@IsActive,NOW(),@updatePK,NOW(),@createPK)", // new MySqlParameter("@labTestDetailPK", pk), // new MySqlParameter("@labTestPK", int.Parse(txtCode.Tag.ToString())), // new MySqlParameter("@specimen", txtSpecimen.Text.Trim()), // new MySqlParameter("@information", txtInfo.Text.Trim()), // new MySqlParameter("@reference", txtRef.Text.Trim()), // new MySqlParameter("@tat", txtTat.Text.Trim()), // new MySqlParameter("@method", txtMethod.Text.Trim()), // new MySqlParameter("@daysSetup", txtDays.Text.Trim()), // new MySqlParameter("@clinicalUsage", txtUsage.Text.Trim()), // new MySqlParameter("@IsActive", chkIsActive.EditValue), // new MySqlParameter("@updatePK", AppVariable.CURRENT_USER_PK.ToString()), // new MySqlParameter("@createPK", AppVariable.CURRENT_USER_PK)); //} sysLogs.logsDetail(int.Parse(AppVariable.CURRENT_SUB_MENU.ToString()), "Update Test Name."); MessageBox.Show("Update is successful.", "MediPro :: Clinic System", MessageBoxButtons.OK, MessageBoxIcon.Information); } } else { int labTestPK = SqlDb.ExecuteScalar <int>("Call getID ('tblLabSubTest')"); int LabIDCnt = SqlDb.ExecuteScalar <int>("SELECT COUNT(*) FROM tblLabSubTest WHERE labSubTestPK=@labSubTestPK AND isDelete=0", new MySqlParameter("@labSubTestPK", labTestPK)); if (LabIDCnt < 1) { SqlDb.ExecuteQuery("INSERT INTO tblLabSubTest(labSubTestPK,labSubTestCode,labSubTestName,labSubTestDescription,specimen,information,reference,tat,method,daysSetup,clinicalUsage,labTestPK, isActive,updateDate,updatePK,createDate,createPK) " + "VALUES(@labSubTestPK,@labSubTestCode,@LabSubTestName,@labSubTestDescription,@specimen,@information,@reference,@tat,@method,@daysSetup,@clinicalUsage,@labTestPK, @IsActive,NOW(),@updatePK,NOW(),@createPK)", new MySqlParameter("@labTestPK", cboLabTest.SelectedValue), new MySqlParameter("@labSubTestPK", labTestPK), new MySqlParameter("@labSubTestCode", txtCode.Text.Trim()), new MySqlParameter("@labSubTestName", txtName.Text.Trim()), new MySqlParameter("@labSubTestDescription", txtDescription.Text.Trim()), new MySqlParameter("@specimen", txtSpecimen.Text.Trim()), new MySqlParameter("@information", txtInfo.Text.Trim()), new MySqlParameter("@reference", txtRef.Text.Trim()), new MySqlParameter("@tat", txtTat.Text.Trim()), new MySqlParameter("@method", txtMethod.Text.Trim()), new MySqlParameter("@daysSetup", txtDays.Text.Trim()), new MySqlParameter("@clinicalUsage", txtUsage.Text.Trim()), new MySqlParameter("@IsActive", chkIsActive.EditValue), new MySqlParameter("@updatePK", AppVariable.CURRENT_USER_PK.ToString()), new MySqlParameter("@createPK", AppVariable.CURRENT_USER_PK)); //if (isDetailExist()) //{ // int pk = SqlDb.ExecuteScalar<int>("getid tblLabTestDetail"); // SqlDb.ExecuteQuery("INSERT INTO tblLabTestDetail(labTestDetailPK,labTestPK, specimen,information,reference,tat,method,daysSetup,clinicalUsage, isActive,updateDate,updatePK,createDate,createPK) " + // "VALUES(@labTestDetailPK,@labTestPK,@specimen,@information,@reference,@tat,@method,@daysSetup,@clinicalUsage,@IsActive,NOW(),@updatePK,NOW(),@createPK)", // new MySqlParameter("@labTestDetailPK", pk), // new MySqlParameter("@labTestPK", labTestPK), // new MySqlParameter("@specimen", txtSpecimen.Text.Trim()), // new MySqlParameter("@information", txtInfo.Text.Trim()), // new MySqlParameter("@reference", txtRef.Text.Trim()), // new MySqlParameter("@tat", txtTat.Text.Trim()), // new MySqlParameter("@method", txtMethod.Text.Trim()), // new MySqlParameter("@daysSetup", txtDays.Text.Trim()), // new MySqlParameter("@clinicalUsage", txtUsage.Text.Trim()), // new MySqlParameter("@IsActive", chkIsActive.EditValue), // new MySqlParameter("@updatePK", AppVariable.CURRENT_USER_PK.ToString()), // new MySqlParameter("@createPK", AppVariable.CURRENT_USER_PK)); //} sysLogs.logsDetail(int.Parse(AppVariable.CURRENT_SUB_MENU.ToString()), "Add New Lab Sub Test Name."); DialogResult dr = MessageBox.Show("Save is successful. Do you want to create another record?", "MediPro :: Clinic System", MessageBoxButtons.YesNo, MessageBoxIcon.Information); if (dr == DialogResult.Yes) { txtCode.Text = string.Empty; txtCode.Tag = string.Empty; txtName.Text = string.Empty; txtDescription.Text = string.Empty; chkIsActive.EditValue = true; txtCode.Focus(); } else { this.Close(); } } } } } }
private void cmdSave_Click(object sender, EventArgs e) { bool IsValid = false; string strErrMsg = ""; if (txtRoleName.Text.Length > 0) { int DupCnt = SqlDb.ExecuteScalar <int>("SELECT COUNT(*) FROM sysRoles WHERE isDelete=0 AND roleName='" + txtRoleName.Text + "' AND rolePK<>" + intRolePK.ToString()); if (DupCnt > 0) { IsValid = false; strErrMsg += "Role name is already exist.\n\r"; } else { IsValid = true; } } else { IsValid = false; strErrMsg += "Role name must be filled.\n\r"; } if (IsValid) { if (intRolePK == 0) { intRolePK = SqlDb.ExecuteScalar <int>("getID 'sysRoles'"); SqlDb.ExecuteQuery("INSERT INTO sysroles(rolePK,roleName,isActive,updateDate,updatePK,createDate,createPK) " + "VALUES(@rolePK,@roleName,@isActive,NOW(),@updatePK,NOW(),@createPK)", new MySqlParameter("@rolePK", intRolePK), new MySqlParameter("@roleName", txtRoleName.Text.Trim()), new MySqlParameter("@isActive", chkIsActive.EditValue), new MySqlParameter("@updatePK", AppVariable.CURRENT_USER_PK), new MySqlParameter("@createPK", AppVariable.CURRENT_USER_PK)); } else { SqlDb.ExecuteQuery("UPDATE sysroles SET roleName=@roleName,isActive=@isActive,updateDate=NOW(),updatePK=@UpdatePK WHERE rolePK=@rolePK", new MySqlParameter("@rolePK", intRolePK.ToString()), new MySqlParameter("@roleName", txtRoleName.Text.Trim()), new MySqlParameter("@isActive", chkIsActive.EditValue), new MySqlParameter("@updatePK", AppVariable.CURRENT_USER_PK.ToString())); } SqlDb.ExecuteQuery("DELETE FROM sysrolepolicy WHERE rolePK=" + intRolePK.ToString()); foreach (DataRow drSave in dtGridSource.Rows) { if (drSave.RowState != DataRowState.Deleted) { int intPolicyPK = int.Parse(drSave["policyPK"].ToString()); bool booIsAllow = bool.Parse(drSave["isAllowed"].ToString()); if (booIsAllow) { SqlDb.ExecuteQuery("INSERT INTO sysrolepolicy (policyPK,rolePK)" + " VALUES(" + intPolicyPK.ToString() + "," + intRolePK.ToString() + ")"); } } } MessageBox.Show("The role has been saved successfully.", "MediPro :: Clinic System", MessageBoxButtons.OK, MessageBoxIcon.Information); } else { MessageBox.Show(strErrMsg, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
private void cmdSave_Click(object sender, EventArgs e) { if (ValidateForm() == true) { int Cnt = SqlDb.ExecuteScalar <int>("SELECT COUNT(*) FROM tblManufacturer WHERE manuName=@manuName AND isDelete=0", new MySqlParameter("@manuName", txtName.Text.Trim())); if (Cnt > 0 && cmdSave.Tag.ToString() == "Add") { MessageBox.Show("Your Manufacturer is already exit. Please check your Manufacturer.", "MediPro :: Clinic System", MessageBoxButtons.OK, MessageBoxIcon.Error); txtName.Focus(); txtName.SelectAll(); } else { if (txtName.Tag.ToString().Length > 0) { int LabIDCnt = SqlDb.ExecuteScalar <int>("SELECT COUNT(*) FROM tblManufacturer WHERE manuPK=@manuPK AND isDelete=0", new MySqlParameter("@manuPK", txtName.Tag.ToString())); if (LabIDCnt > 0) { SqlDb.ExecuteQuery("UPDATE tblManufacturer SET manuName=@manuName, manuContact=@manuContact,manuAddress=@manuAddress,manuEmail=@manuEmail,manuCountry=@manuCountry,isActive=@IsActive,updateDate=NOW(),updatePK=@UpdatePK WHERE manuPK=@manuPK", new MySqlParameter("@manuPK", int.Parse(txtName.Tag.ToString())), new MySqlParameter("@manuName", txtName.Text.Trim()), new MySqlParameter("@manuContact", txtContact.Text.Trim()), new MySqlParameter("@manuAddress", txtAddress.Text.Trim()), new MySqlParameter("@manuEmail", txtEmail.Text.Trim()), new MySqlParameter("@manuCountry", cboCountry.Text.Trim()), new MySqlParameter("@IsActive", chkIsActive.EditValue), new MySqlParameter("@updatePK", AppVariable.CURRENT_USER_PK.ToString())); sysLogs.logsDetail(int.Parse(AppVariable.CURRENT_SUB_MENU.ToString()), "Update Test Name."); MessageBox.Show("Update is successful.", "MediPro :: Clinic System", MessageBoxButtons.OK, MessageBoxIcon.Information); } } else { int LabID = SqlDb.ExecuteScalar <int>("Call getID ('tblManufacturer')"); int LabIDCnt = SqlDb.ExecuteScalar <int>("SELECT COUNT(*) FROM tblManufacturer WHERE manuPK=@manuPK AND isDelete=0", new MySqlParameter("@manuPK", LabID)); if (LabIDCnt < 1) { SqlDb.ExecuteQuery("INSERT INTO tblManufacturer(manuPK,manuName,manuContact,manuAddress,manuEmail,manuCountry,isActive,updateDate,updatePK,createDate,createPK) " + "VALUES(@manuPK,@manuName,@manuContact,@manuAddress,@manuEmail,@manuCountry, @IsActive,NOW(),@updatePK,NOW(),@createPK)", new MySqlParameter("@manuPK", LabID), new MySqlParameter("@manuName", txtName.Text.Trim()), new MySqlParameter("@manuContact", txtContact.Text.Trim()), new MySqlParameter("@manuAddress", txtAddress.Text.Trim()), new MySqlParameter("@manuEmail", txtEmail.Text.Trim()), new MySqlParameter("@manuCountry", cboCountry.Text.Trim()), new MySqlParameter("@IsActive", chkIsActive.EditValue), new MySqlParameter("@updatePK", AppVariable.CURRENT_USER_PK), new MySqlParameter("@createPK", AppVariable.CURRENT_USER_PK)); sysLogs.logsDetail(int.Parse(AppVariable.CURRENT_SUB_MENU.ToString()), "Add New Manufacturer."); DialogResult dr = MessageBox.Show("Save is successful. Do you want to create another record?", "MediPro :: Clinic System", MessageBoxButtons.YesNo, MessageBoxIcon.Information); if (dr == DialogResult.Yes) { txtName.Text = string.Empty; txtName.Tag = string.Empty; txtContact.Text = string.Empty; txtAddress.Text = string.Empty; txtEmail.Text = string.Empty; cboCountry.Text = string.Empty; chkIsActive.EditValue = true; txtName.Focus(); } else { this.Close(); } } } } } }
private void cmdSave_Click(object sender, EventArgs e) { if (ValidateForm() == true) { int patientCnt; if (radioNewPatient.Checked == true) { patientCnt = SqlDb.ExecuteScalar <int>("SELECT COUNT(*) FROM tblBooking WHERE patientName=@PatientName AND doctorPK=@DoctorPK AND abdate=@ABDate", new MySqlParameter("@PatientName", txtPatientName.Text), new MySqlParameter("@DoctorPK", doctorPK), new MySqlParameter("@ABDate", dtBoooking.Date.ToString("yyyy-MM-dd"))); } else { patientCnt = SqlDb.ExecuteScalar <int>("SELECT COUNT(*) FROM tblBooking WHERE patientName=@PatientName AND doctorPK=@DoctorPK AND abdate=@ABDate", new MySqlParameter("@PatientName", luePatient.Text), new MySqlParameter("@DoctorPK", doctorPK), new MySqlParameter("@ABDate", dtBoooking.Date.ToString("yyyy-MM-dd"))); } if (patientCnt > 0) { DialogResult = MessageBox.Show("Please check your booking list. This patient's name was booked. Are you sure?", "MediPro :: Clinic System", MessageBoxButtons.YesNo, MessageBoxIcon.Information); if (DialogResult == DialogResult.Yes) { Save(); } } else { Save(); } } }
private void cmdSave_Click(object sender, EventArgs e) { if (ValidateForm() == true) { int LabCnt = SqlDb.ExecuteScalar <int>("SELECT COUNT(*) FROM tblLabPackage WHERE labPackName=@labPackName AND isDelete=0 AND labPackPK <>@labPackPK", new MySqlParameter("@labPackName", txtName.Text.Trim()), new MySqlParameter("@labPackPK", txtName.Tag)); if (LabCnt > 0) { MessageBox.Show("Your Lab Package name is already exit. Please check your Lab Package name.", "MediPro :: Clinic System", MessageBoxButtons.OK, MessageBoxIcon.Error); txtName.Focus(); txtName.SelectAll(); } else { if (txtName.Tag.ToString().Length > 0) { int LabIDCnt = SqlDb.ExecuteScalar <int>("SELECT COUNT(*) FROM tblLabPackage WHERE labPackPK=@labPackPK AND isDelete=0", new MySqlParameter("@labPackPK", txtName.Tag.ToString())); if (LabIDCnt > 0) { SqlDb.ExecuteQuery("UPDATE tblLabPackage SET labPackName=@labPackName,labPK=@labPK,isActive=@IsActive,updateDate=NOW(),updatePK=@UpdatePK WHERE labPackPK=@labPackPK", new MySqlParameter("@labPackPK", int.Parse(txtName.Tag.ToString())), new MySqlParameter("@labPK", cboLab.SelectedValue), new MySqlParameter("@labPackName", txtName.Text.Trim()), new MySqlParameter("@IsActive", chkIsActive.EditValue), new MySqlParameter("@updatePK", AppVariable.CURRENT_USER_PK.ToString())); SqlDb.ExecuteNonQuery("Delete from tblLabPackageDetail where labPackPK=@labPackPK", new MySqlParameter("@labPackPK", txtName.Tag)); for (int i = 0; i < dgvPicked.Rows.Count; i++) { SqlDb.ExecuteQuery("Insert into tblLabPackageDetail(labPackPK,labTestPK,createPK,createDate,updatePK,updateDate)" + "values(@labPackPK,@labTestPK,@createPK,NOW(),@updatePK,NOW())", new MySqlParameter("@labPackPK", txtName.Tag), new MySqlParameter("@labTestPK", dgvPicked.Rows[i].Cells[0].Value), new MySqlParameter("@updatePK", AppVariable.CURRENT_USER_PK), new MySqlParameter("@createPK", AppVariable.CURRENT_USER_PK) ); } sysLogs.logsDetail(int.Parse(AppVariable.CURRENT_SUB_MENU.ToString()), "Update Test Name."); MessageBox.Show("Update is successful.", "MediPro :: Clinic System", MessageBoxButtons.OK, MessageBoxIcon.Information); } } else { int LabID = SqlDb.ExecuteScalar <int>("Call getID ('tblLabPackage')"); int LabIDCnt = SqlDb.ExecuteScalar <int>("SELECT COUNT(*) FROM tblLabPackage WHERE labPackPK=@labPackPK AND isDelete=0", new MySqlParameter("@labPackPK", LabID)); if (LabIDCnt < 1) { SqlDb.ExecuteQuery("INSERT INTO tblLabPackage(labPackPK,labPackName,labPK,isActive,updateDate,updatePK,createDate,createPK) " + "VALUES(@labPackPK,@labPackName,@labPK,@IsActive,NOW(),@updatePK,NOW(),@createPK)", new MySqlParameter("@labPackPK", LabID), new MySqlParameter("@labPackName", txtName.Text.Trim()), new MySqlParameter("@labPK", cboLab.SelectedValue), new MySqlParameter("@IsActive", chkIsActive.EditValue), new MySqlParameter("@updatePK", AppVariable.CURRENT_USER_PK), new MySqlParameter("@createPK", AppVariable.CURRENT_USER_PK)); for (int i = 0; i < dgvPicked.Rows.Count; i++) { SqlDb.ExecuteQuery("Insert into tblLabPackageDetail(labPackPK,labTestPK,createPK,createDate,updatePK,updateDate)" + "values(@labPackPK,@labTestPK,@createPK,NOW(),@updatePK,NOW())", new MySqlParameter("@labPackPK", LabID), new MySqlParameter("@labTestPK", dgvPicked.Rows[i].Cells[0].Value), new MySqlParameter("@updatePK", AppVariable.CURRENT_USER_PK), new MySqlParameter("@createPK", AppVariable.CURRENT_USER_PK) ); } sysLogs.logsDetail(int.Parse(AppVariable.CURRENT_SUB_MENU.ToString()), "Add New Lab Package."); DialogResult dr = MessageBox.Show("Save is successful. Do you want to create other Package?", "MediPro :: Clinic System", MessageBoxButtons.YesNo, MessageBoxIcon.Information); if (dr == DialogResult.Yes) { txtName.Text = string.Empty; txtName.Tag = string.Empty; cboLab.SelectedIndex = -1; dgv.Rows.Clear(); dgvPicked.Rows.Clear(); DataTable dt = SqlDb.GetDataSet("Select labTestPK,labTestName from tblLabTest").Tables[0]; foreach (DataRow ddr in dt.Rows) { dgv.Rows.Add(ddr.ItemArray); } chkIsActive.EditValue = true; txtName.Focus(); } else { this.Close(); } } } } } }
private void cmdSave_Click(object sender, EventArgs e) { if (ValidateForm() == true) { int visitCnt = 0; if (cmdSave.Tag.ToString().Length > 0) { visitCnt = SqlDb.ExecuteScalar <int>("SELECT COUNT(*) FROM tblVisit WHERE visitPK=@VisitPK", new MySqlParameter("@VisitPK", dteVisitDate.Tag.ToString())); } if (visitCnt < 1) { string VisitPK = SqlDb.ExecuteScalar <string>("getVisitNo N'tblVisit','" + dtVisit.ToString("yyyy-MM-dd") + "'"); SqlDb.ExecuteQuery("INSERT INTO tblVisit(visitPK,RegNo,visitDate,visitDescription,doctorPK,visitWeight,visitFeet,inch,bmi,bloodType,createPK,createDate) " + "VALUES(@VisitPK,@RegNo,@VisitDate,@VisitDescription,@DoctorPK,@VisitWeight,@VisitFeet,@Inch,@BMI,@BloodType,@CreatePK,NOW())", new MySqlParameter("@VisitPK", VisitPK), new MySqlParameter("@RegNo", txtRegNo.Text.Trim()), new MySqlParameter("@VisitDate", dtVisit.ToString("yyyy-MM-dd")), new MySqlParameter("@VisitDescription", txtDescription.Text), new MySqlParameter("@DoctorPK", lueDoctor.EditValue), new MySqlParameter("@VisitWeight", txtWeight.Text), new MySqlParameter("@VisitFeet", txtft.Text), new MySqlParameter("@Inch", txtin.Text), new MySqlParameter("@BMI", txtBMI.Text), new MySqlParameter("@BloodType", cboBloodType.Text), new MySqlParameter("@CreatePK", AppVariable.CURRENT_USER_PK)); SqlDb.ExecuteQuery("UPDATE tblBooking SET doctorPK=@DoctorPK,visitPK=@VisitPK, isVisited=1 WHERE PK=@PK", new MySqlParameter("@PK", cmdSave.Tag.ToString()), new MySqlParameter("@DoctorPK", lueDoctor.EditValue), new MySqlParameter("@VisitPK", VisitPK)); sysLogs.logsDetail(int.Parse(AppVariable.CURRENT_SUB_MENU.ToString()), "Add New Visit."); MessageBox.Show("Save is successful.", "MediPro :: Clinic System", MessageBoxButtons.OK, MessageBoxIcon.Information); } else { SqlDb.ExecuteQuery("UPDATE tblVisit SET RegNo=@RegNo,visitDate=@VisitDate,visitDescription=@VisitDescription," + "doctorPK=@DoctorPK,visitWeight=@VisitWeight,visitFeet=@VisitFeet,inch=@Inch,bmi=@BMI,bloodType=@BloodType," + "updateDate=NOW(),updatePK=@UpdatePK WHERE visitPK=@VisitPK", new MySqlParameter("@VisitPK", dteVisitDate.Tag.ToString()), new MySqlParameter("@RegNo", txtRegNo.Text.Trim()), new MySqlParameter("@VisitDate", dtVisit.ToString("yyyy-MM-dd")), new MySqlParameter("@VisitDescription", txtDescription.Text), new MySqlParameter("@DoctorPK", lueDoctor.EditValue), new MySqlParameter("@VisitWeight", txtWeight.Text), new MySqlParameter("@VisitFeet", txtft.Text), new MySqlParameter("@Inch", txtin.Text), new MySqlParameter("@BMI", txtBMI.Text), new MySqlParameter("@BloodType", cboBloodType.Text), new MySqlParameter("@updatePK", AppVariable.CURRENT_USER_PK)); sysLogs.logsDetail(int.Parse(AppVariable.CURRENT_SUB_MENU.ToString()), "Update Visit."); MessageBox.Show("Update is successful.", "MediPro :: Clinic System", MessageBoxButtons.OK, MessageBoxIcon.Information); } } }
private void cmdSave_Click(object sender, EventArgs e) { bool IsValid = false; string strErrMsg = ""; if (txtMedName.Text.Length > 0) { int DupCnt = SqlDb.ExecuteScalar <int>("SELECT COUNT(*) FROM tblMedicine WHERE isDelete=0 AND medName='" + txtMedName.Text + "' AND medPK<>" + intMedPK.ToString()); if (DupCnt > 0) { IsValid = false; strErrMsg += "Brand name is already exist.\n\r"; } else { IsValid = true; } } else { IsValid = false; strErrMsg += "Brand name must be filled.\n\r"; } if (IsValid) { MemoryStream ms = new MemoryStream(); if (null != imgImage.Image) { imgImage.Image.Save(ms, ImageFormat.Jpeg); } //Read from MemoryStream into Byte array. Byte[] bytImgData = new Byte[ms.Length]; ms.Position = 0; ms.Read(bytImgData, 0, Convert.ToInt32(ms.Length)); if (intMedPK == 0) { intMedPK = SqlDb.ExecuteScalar <int>("Call getID ('tblMedicine')"); SqlDb.ExecuteQuery("INSERT INTO tblMedicine(medPK,medName,medTypePK,chemNamePK,systemPK " + ",manuPK,indicationEng,indicationMyan,dosageEng,dosageMyan,isActive " + ",updatePK,updateDate,createPK,createDate,image) " + "VALUES(@medPK,@medName,@medTypePK,@chemNamePK,@systemPK " + ",@manuPK,@indicationEng,@indicationMyan,@dosageEng,@dosageMyan,@isActive " + ",@updatePK,NOW(),@createPK,NOW(),@image)", new MySqlParameter("@medPK", intMedPK), new MySqlParameter("@medName", txtMedName.Text.Trim()), new MySqlParameter("@medTypePK", cboMedTypePK.SelectedValue), new MySqlParameter("@chemNamePK", cboChemPK.SelectedValue), new MySqlParameter("@systemPK", cboSystemPK.SelectedValue), new MySqlParameter("@manuPK", cboManuPK.SelectedValue), new MySqlParameter("@indicationEng", txtIndicationEng.Text.Trim()), new MySqlParameter("@indicationMyan", txtIndicationMyan.Text.Trim()), new MySqlParameter("@dosageEng", txtDosageEng.Text.Trim()), new MySqlParameter("@dosageMyan", txtDosageMyan.Text.Trim()), new MySqlParameter("@isActive", chkIsActive.EditValue), new MySqlParameter("@updatePK", AppVariable.CURRENT_USER_PK), new MySqlParameter("@createPK", AppVariable.CURRENT_USER_PK), new MySqlParameter("@image", MySqlDbType.VarBinary, bytImgData.Length, ParameterDirection.Input, false, 0, 0, null, DataRowVersion.Current, bytImgData)); DialogResult dr = MessageBox.Show("The medicine has been saved successfully. Do you want to create other medicine?", "MediPro :: Clinic System", MessageBoxButtons.YesNo, MessageBoxIcon.Information); if (dr == DialogResult.Yes) { FormClean(); txtMedName.Focus(); } } else { SqlDb.ExecuteQuery("UPDATE tblMedicine SET medName=@medName, medTypePK=@medTypePK, chemNamePK=@chemNamePK, systemPK=@systemPK " + ",manuPK=@manuPK, indicationEng=@indicationEng, indicationMyan=@indicationMyan, dosageEng=@dosageEng " + ",dosageMyan=@dosageMyan, isActive=@isActive, updatePK=@updatePK,updateDate=NOW(),image=@image where medPK=@medPK", new MySqlParameter("@medPK", intMedPK), new MySqlParameter("@medName", txtMedName.Text.Trim()), new MySqlParameter("@medTypePK", cboMedTypePK.SelectedValue), new MySqlParameter("@chemNamePK", cboChemPK.SelectedValue), new MySqlParameter("@systemPK", cboSystemPK.SelectedValue), new MySqlParameter("@manuPK", cboManuPK.SelectedValue), new MySqlParameter("@indicationEng", txtIndicationEng.Text.Trim()), new MySqlParameter("@indicationMyan", txtIndicationMyan.Text.Trim()), new MySqlParameter("@dosageEng", txtDosageEng.Text.Trim()), new MySqlParameter("@dosageMyan", txtDosageMyan.Text.Trim()), new MySqlParameter("@isActive", chkIsActive.EditValue), new MySqlParameter("@updatePK", AppVariable.CURRENT_USER_PK), new MySqlParameter("@image", MySqlDbType.VarBinary, bytImgData.Length, ParameterDirection.Input, false, 0, 0, null, DataRowVersion.Current, bytImgData)); MessageBox.Show("The medicine has been saved successfully.", "MediPro :: Clinic System", MessageBoxButtons.OK, MessageBoxIcon.Information); } SqlDb.ExecuteQuery("DELETE FROM tblPackList WHERE packlistPK=" + intMedPK.ToString()); foreach (DataRow drSave in dtGridSource.Rows) { if (drSave.RowState != DataRowState.Deleted) { int intFromUnit = int.Parse(drSave["fromUnitPK"].ToString()); int intToUnit = int.Parse(drSave["toUnitPK"].ToString()); if ((intFromUnit > 0) && (intToUnit > 0)) { SqlDb.ExecuteQuery("INSERT INTO tblPackList(medPK, toUnitPK, fromUnitPK, fromValue)" + " VALUES(" + intMedPK.ToString() + "," + drSave["toUnitPK"].ToString() + "," + drSave["fromUnitPK"].ToString() + "," + drSave["fromValue"].ToString() + ")"); } } } } else { MessageBox.Show(strErrMsg, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
private void cmdSave_Click(object sender, EventArgs e) { if (ValidateForm() == true) { int UserLevelCnt = SqlDb.ExecuteScalar <int>("SELECT COUNT(*) FROM sysUserLevel WHERE user_level=@UserLevel AND isDeleted=0", new MySqlParameter("@UserLevel", txtUserLevel.Text.Trim())); if (UserLevelCnt > 0 && cmdSave.Tag.ToString() == "Add") { MessageBox.Show("Your user level is already exit. Please check your user level.", "MediPro :: Clinic System", MessageBoxButtons.OK, MessageBoxIcon.Error); txtUserLevel.SelectAll(); } else { if (txtUserLevel.Tag.ToString().Length > 0) { int UserLevelIDCnt = SqlDb.ExecuteScalar <int>("SELECT COUNT(*) FROM sysUserLevel WHERE levelPK=@LevelPK AND isDeleted=0", new MySqlParameter("@LevelPK", txtUserLevel.Tag.ToString())); if (UserLevelIDCnt > 0) { SqlDb.ExecuteQuery("UPDATE sysUserLevel SET UserLevel=@UserLevel,IsActive=@IsActive,updatedDate=@updatedDate WHERE levelPK=@LevelPK", new MySqlParameter("@LevelPK", int.Parse(Convert.ToString(txtUserLevel.Tag))), new MySqlParameter("@UserLevel", txtUserLevel.Text), new MySqlParameter("@IsActive", chkIsActive.EditValue), new MySqlParameter("@updatedDate", DateTime.Now)); sysLogs.logsDetail(int.Parse(AppVariable.CURRENT_SUB_MENU.ToString()), "Update User Level."); MessageBox.Show("Update is successful.", "MediPro :: Clinic System", MessageBoxButtons.OK, MessageBoxIcon.Information); } } else { int CurUserLevelID = SqlDb.ExecuteScalar <int>("Call getID ('sysUserLevel')"); int UserLevelIDCnt = SqlDb.ExecuteScalar <int>("SELECT COUNT(*) FROM sysUserLevel WHERE levelPK=@LevelPK AND isDeleted=0", new MySqlParameter("@LevelPK", CurUserLevelID)); if (UserLevelIDCnt < 1) { SqlDb.ExecuteQuery("INSERT INTO sysUserLevel(levelPK,UserLevel,IsActive,updatedDate,createdDate) " + "VALUES(@LevelPK,@UserLevel,@IsActive,@updatedDate,@createdDate)", new MySqlParameter("@LevelPK", CurUserLevelID), new MySqlParameter("@UserLevel", txtUserLevel.Text), new MySqlParameter("@IsActive", chkIsActive.EditValue), new MySqlParameter("@updatedDate", DateTime.Now), new MySqlParameter("@createdDate", DateTime.Now)); sysLogs.logsDetail(int.Parse(AppVariable.CURRENT_SUB_MENU.ToString()), "Add New User Level."); DataSet dsMainMenu = SqlDb.GetDataSet("SELECT PK FROM sysMainMenu"); for (int i = 0; i < dsMainMenu.Tables[0].Rows.Count; i++) { SqlDb.ExecuteQuery("INSERT INTO sysMainMenuDefine(mainmenuPK,levelPK,IsView) VALUES(@MainMenuPK,@LevelPK,@IsView)", new MySqlParameter("@MainMenuPK", int.Parse(dsMainMenu.Tables[0].Rows[i]["PK"].ToString())), new MySqlParameter("@LevelPK", CurUserLevelID), new MySqlParameter("@IsView", true)); DataSet dsSubMenu = SqlDb.GetDataSet("SELECT PK FROM sysSubMenu WHERE mainPK = @MainMenuPK", new MySqlParameter("@MainMenuPK", int.Parse(dsMainMenu.Tables[0].Rows[i]["PK"].ToString()))); for (int s = 0; s < dsSubMenu.Tables[0].Rows.Count; s++) { SqlDb.ExecuteQuery("INSERT INTO sysLevelDefine(levelPK,mainmenuPK,submenuPK,dataView,dataInsert,dataEdit,dataDelete,dataPrint) " + "VALUES(@LevelPK,@MainMenuPK,@SubMenuPK,@DataView,@DataInsert,@DataEdit,@DataDelete,@DataPrint)", new MySqlParameter("@LevelPK", CurUserLevelID), new MySqlParameter("@SubMenuPK", int.Parse(dsSubMenu.Tables[0].Rows[s]["PK"].ToString())), new MySqlParameter("@MainMenuPK", int.Parse(dsMainMenu.Tables[0].Rows[i]["PK"].ToString())), new MySqlParameter("@DataView", true), new MySqlParameter("@DataInsert", true), new MySqlParameter("@DataEdit", true), new MySqlParameter("@DataDelete", true), new MySqlParameter("@DataPrint", true)); } } DialogResult = MessageBox.Show("Save is successful. Do you want to create new user level?", "MediPro :: Clinic System", MessageBoxButtons.YesNo, MessageBoxIcon.Information); if (DialogResult == DialogResult.Yes) { txtUserLevel.Text = string.Empty; txtUserLevel.Tag = string.Empty; chkIsActive.EditValue = true; txtUserLevel.Focus(); } else { this.Close(); } } } } } }
private void cmdSave_Click(object sender, EventArgs e) { if (ValidateForm() == true) { int LabCnt = SqlDb.ExecuteScalar <int>("SELECT COUNT(*) FROM tblagent WHERE agentName=@agentName and agentPK<>@agentPK ", new MySqlParameter("@agentName", txtName.Text.Trim()), new MySqlParameter("@agentPK", txtName.Tag)); if (LabCnt > 0) { MessageBox.Show("Agent Name you provided is already exit. Please check your Agent name.", "MediPro :: Clinic System", MessageBoxButtons.OK, MessageBoxIcon.Error); txtName.Focus(); txtName.SelectAll(); } else { if (txtName.Tag.ToString().Length > 0) { int LabIDCnt = SqlDb.ExecuteScalar <int>("SELECT COUNT(*) FROM tblAgent WHERE agentPK=@agentPK ", new MySqlParameter("@agentPK", txtName.Tag.ToString())); if (LabIDCnt > 0) { SqlDb.ExecuteQuery("UPDATE tblAgent SET agentName=@agentName,agentAddress=@agentAddress,agentPhone=@agentPhone,agentRemarks=@agentRemarks,updateDate=NOW(),updatePK=@UpdatePK WHERE agentPK=@agentPK", new MySqlParameter("@agentPK", int.Parse(txtName.Tag.ToString())), new MySqlParameter("@agentName", txtName.Text.Trim()), new MySqlParameter("@agentAddress", txtAddress.Text.Trim()), new MySqlParameter("@agentPhone", txtPhone.Text.Trim()), new MySqlParameter("@agentRemarks", txtRemarks.Text.Trim()), new MySqlParameter("@IsActive", chkIsActive.EditValue), new MySqlParameter("@updatePK", AppVariable.CURRENT_USER_PK.ToString())); sysLogs.logsDetail(int.Parse(AppVariable.CURRENT_SUB_MENU.ToString()), "Update Agent Name."); MessageBox.Show("Update is successful.", "MediPro :: Clinic System", MessageBoxButtons.OK, MessageBoxIcon.Information); } } else { int LabID = SqlDb.ExecuteScalar <int>("Call getID ('tblagent')"); int LabIDCnt = SqlDb.ExecuteScalar <int>("SELECT COUNT(*) FROM tblAgent WHERE agentPK=@agentPK", new MySqlParameter("@agentPK", LabID)); if (LabIDCnt < 1) { SqlDb.ExecuteQuery("INSERT INTO tblAgent(agentPK,agentName,agentPhone,agentAddress,agentRemarks,updateDate,updatePK,createDate,createPK) " + "VALUES(@agentPK,@agentName,@agentPhone,@agentAddress,@agentRemarks,NOW(),@updatePK,NOW(),@createPK)", new MySqlParameter("@agentPK", LabID), new MySqlParameter("@agentName", txtName.Text.Trim()), new MySqlParameter("@agentAddress", txtAddress.Text.Trim()), new MySqlParameter("@agentPhone", txtPhone.Text.Trim()), new MySqlParameter("@agentRemarks", txtRemarks.Text.Trim()), new MySqlParameter("@updatePK", AppVariable.CURRENT_USER_PK), new MySqlParameter("@createPK", AppVariable.CURRENT_USER_PK)); sysLogs.logsDetail(int.Parse(AppVariable.CURRENT_SUB_MENU.ToString()), "Add New Agent Name."); DialogResult dr = MessageBox.Show("Save is successful. Do you want to create other test name?", "MediPro :: Clinic System", MessageBoxButtons.YesNo, MessageBoxIcon.Information); if (dr == DialogResult.Yes) { txtName.Text = string.Empty; txtName.Tag = string.Empty; txtRemarks.Text = string.Empty; txtAddress.Text = string.Empty; txtPhone.Text = string.Empty; chkIsActive.EditValue = true; txtName.Focus(); } else { this.Close(); } } } } } }
private void cmdSave_Click(object sender, EventArgs e) { bool IsValid = false; string strErrMsg = ""; int intPackListID = int.Parse(txtPackListTempName.Tag.ToString()); if (txtPackListTempName.Text.Length > 0) { int DupCnt = SqlDb.ExecuteScalar <int>("SELECT COUNT(*) FROM tblPackListTemp WHERE isDelete=0 AND packListName='" + txtPackListTempName.Text + "' AND packListPK<>" + intPackListID.ToString()); if (DupCnt > 0) { IsValid = false; strErrMsg += "Template name is already exist.\n\r"; } else { IsValid = true; } } else { IsValid = false; strErrMsg += "Template name must be filled.\n\r"; } if (IsValid) { if (intPackListID == 0) { intPackListID = SqlDb.ExecuteScalar <int>("Call getID ('tblPackListTemp')"); SqlDb.ExecuteQuery("INSERT INTO tblPackListTemp(packListPK,packListName,isActive,updateDate,updatePK,createDate,createPK) " + "VALUES(@packListPK,@packListName,@isActive,NOW(),@updatePK,NOW(),@createPK)", new MySqlParameter("@packListPK", intPackListID), new MySqlParameter("@packListName", txtPackListTempName.Text.Trim()), new MySqlParameter("@isActive", chkIsActive.EditValue), new MySqlParameter("@updatePK", AppVariable.CURRENT_USER_PK), new MySqlParameter("@createPK", AppVariable.CURRENT_USER_PK)); DialogResult dr = MessageBox.Show("The template has been saved successfully. Do you want to create other template?", "MediPro :: Clinic System", MessageBoxButtons.YesNo, MessageBoxIcon.Information); if (dr == DialogResult.Yes) { txtPackListTempName.Text = string.Empty; txtPackListTempName.Tag = string.Empty; chkIsActive.EditValue = true; txtPackListTempName.Focus(); } } else { SqlDb.ExecuteQuery("UPDATE tblPackListTemp SET packListName=@packListName,isActive=@isActive,updateDate=NOW(),updatePK=@UpdatePK WHERE packListPK=@packListPK", new MySqlParameter("@packListPK", intPackListID.ToString()), new MySqlParameter("@packListName", txtPackListTempName.Text.Trim()), new MySqlParameter("@isActive", chkIsActive.EditValue), new MySqlParameter("@updatePK", AppVariable.CURRENT_USER_PK.ToString())); MessageBox.Show("The template has been saved successfully.", "MediPro :: Clinic System", MessageBoxButtons.OK, MessageBoxIcon.Information); } SqlDb.ExecuteQuery("DELETE FROM tblPackListTempDetail WHERE packlistPK=" + intPackListID.ToString()); foreach (DataRow drSave in dtGridSource.Rows) { if (drSave.RowState != DataRowState.Deleted) { int intFromUnit = int.Parse(drSave["fromUnitPK"].ToString()); int intToUnit = int.Parse(drSave["toUnitPK"].ToString()); if ((intFromUnit > 0) && (intToUnit > 0)) { SqlDb.ExecuteQuery("INSERT INTO tblPackListTempDetail(packListPK,toUnitPK, fromUnitPK, fromValue)" + " VALUES(" + intPackListID.ToString() + "," + drSave["toUnitPK"].ToString() + "," + drSave["fromUnitPK"].ToString() + "," + drSave["fromValue"].ToString() + ")"); } } } } else { MessageBox.Show(strErrMsg, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
private void cmdSave_Click(object sender, EventArgs e) { if (ValidateForm() == true) { int UserCnt = SqlDb.ExecuteScalar <int>("SELECT COUNT(*) FROM sysUser WHERE login=@Login AND isDelete =0", new MySqlParameter("@login", txtLoginID.Text.Trim())); if (UserCnt > 0 && cmdSave.Tag.ToString() == "Add") { MessageBox.Show("Your Login ID is already exit. Please check your Login ID.", "Error Message", MessageBoxButtons.OK, MessageBoxIcon.Error); txtLoginID.SelectAll(); } else { if (txtLoginID.Tag.ToString().Length > 0) { int UserIDCnt = SqlDb.ExecuteScalar <int>("SELECT COUNT(*) FROM sysUser WHERE PK=@PK AND isDelete=0", new MySqlParameter("@PK", txtLoginID.Tag.ToString())); if (UserIDCnt > 0) { SqlDb.ExecuteQuery("UPDATE sysUser SET name=@FullName,login=@LoginID,levelPK=@LevelPK,IsActive=@IsActive,updateDate=NOW() WHERE PK=@UserID", new MySqlParameter("@UserID", int.Parse(Convert.ToString(txtLoginID.Tag))), new MySqlParameter("@FullName", txtFullName.Text), new MySqlParameter("@LoginID", txtLoginID.Text), new MySqlParameter("@LevelPK", cboUserLevel.SelectedValue), new MySqlParameter("@IsActive", chkIsActive.EditValue)); sysLogs.logsDetail(int.Parse(AppVariable.CURRENT_SUB_MENU.ToString()), "Update User Info."); MessageBox.Show("Update is successful.", "MediPro :: Clinic System", MessageBoxButtons.OK, MessageBoxIcon.Information); } } else { int CurUserID = SqlDb.ExecuteScalar <int>("Call getID ('sysUser')"); int UserIDCnt = SqlDb.ExecuteScalar <int>("SELECT COUNT(*) FROM sysUser WHERE PK=@UserID AND isDelete=0", new MySqlParameter("@UserID", CurUserID)); if (UserIDCnt < 1) { string pwd = Crypto.Encrypt("passw0rd"); SqlDb.ExecuteQuery("INSERT INTO sysUser(PK,name,login,passw,levelPK,IsActive,updateDate,createDate) " + "VALUES(@UserID,@FullName,@LoginID,@PSW,@LevelPK,@IsActive,NOW(),NOW())", new MySqlParameter("@UserID", CurUserID), new MySqlParameter("@FullName", txtFullName.Text), new MySqlParameter("@LoginID", txtLoginID.Text), new MySqlParameter("@LevelPK", cboUserLevel.SelectedValue), new MySqlParameter("@PSW", pwd), new MySqlParameter("@IsActive", chkIsActive.EditValue)); sysLogs.logsDetail(int.Parse(AppVariable.CURRENT_SUB_MENU.ToString()), "Add New User"); DialogResult = MessageBox.Show("Save is successful. Do you want to create new user?", "MediPro :: Clinic System", MessageBoxButtons.YesNo, MessageBoxIcon.Information); if (DialogResult == DialogResult.Yes) { FormClean(); txtFullName.Focus(); } else { this.Close(); } } } } } }
private void cmdSave_Click(object sender, EventArgs e) { if (ValidateForm() == true) { int DocCnt = SqlDb.ExecuteScalar <int>("SELECT COUNT(*) FROM tblDoctor WHERE doctor=@Doctor AND isDelete=0", new MySqlParameter("@Doctor", txtName.Text.Trim())); if (DocCnt > 0 && cmdSave.Tag.ToString() == "Add") { MessageBox.Show("Your doctor name is already exit. Please check your title.", "MediPro :: Clinic System", MessageBoxButtons.OK, MessageBoxIcon.Error); txtName.Focus(); txtName.SelectAll(); } else { if (txtName.Tag.ToString().Length > 0) { int DocIDCnt = SqlDb.ExecuteScalar <int>("SELECT COUNT(*) FROM tblDoctor WHERE doctorPK=@DoctorPK AND isDelete=0", new MySqlParameter("@DoctorPK", txtName.Tag.ToString())); if (DocIDCnt > 0) { if (DublicateSAMA() == true) { SqlDb.ExecuteQuery("UPDATE tblDoctor SET doctor=@Doctor,titlePK=@TitlePK,specializePK=@SpecializePK,gender=@Gender,positionPK=@PositionPK," + "samaNo=@SamaNo,homePhone=@HomePhone,mobilePhone=@MobilePhone,email=@Email,address=@Address,isActive=@IsActive," + "updateDate=NOW(),updatePK=@UpdatePK WHERE doctorPK=@DoctorPK", new MySqlParameter("@DoctorPK", int.Parse(txtName.Tag.ToString())), new MySqlParameter("@Doctor", txtName.Text.Trim()), new MySqlParameter("@TitlePK", cboTitle.SelectedValue), new MySqlParameter("@SpecializePK", cboSpecialize.SelectedValue), new MySqlParameter("@Gender", cboGender.Text), new MySqlParameter("@PositionPK", cboPosition.SelectedValue), new MySqlParameter("@SamaNo", txtSAMA.Text.Trim()), new MySqlParameter("@HomePhone", txtHomePhone.Text.Trim()), new MySqlParameter("@MobilePhone", txtMobilePhone.Text.Trim()), new MySqlParameter("@Email", txtEmail.Text.Trim()), new MySqlParameter("@Address", txtAddress.Text.Trim()), new MySqlParameter("@IsActive", chkIsActive.EditValue), new MySqlParameter("@updatePK", AppVariable.CURRENT_USER_PK)); sysLogs.logsDetail(int.Parse(AppVariable.CURRENT_SUB_MENU.ToString()), "Update Doctor."); MessageBox.Show("Update is successful.", "MediPro :: Clinic System", MessageBoxButtons.OK, MessageBoxIcon.Information); } } } else { if (DublicateSAMA() == true) { int DocID = SqlDb.ExecuteScalar <int>("Call getID ('tblDoctor')"); int DcoIDCnt = SqlDb.ExecuteScalar <int>("SELECT COUNT(*) FROM tblDoctor WHERE doctorPK=@DoctorPK AND isDelete=0", new MySqlParameter("@DoctorPK", DocID)); if (DcoIDCnt < 1) { SqlDb.ExecuteQuery("INSERT INTO tblDoctor(doctorPK,doctor,titlePK,specializePK,gender,positionPK,samaNo,homePhone,mobilePhone,email,address,isActive,createPK,createDate,updatePK,updateDate) " + "VALUES(@DoctorPK,@Doctor,@TitlePK,@SpecializePK,@Gender,@PositionPK,@SamaNo,@HomePhone,@MobilePhone,@Email,@Address,@IsActive,@CreatePK,NOW(),@UpdatePK,NOW())", new MySqlParameter("@DoctorPK", DocID), new MySqlParameter("@Doctor", txtName.Text.Trim()), new MySqlParameter("@TitlePK", cboTitle.SelectedValue), new MySqlParameter("@SpecializePK", cboSpecialize.SelectedValue), new MySqlParameter("@Gender", cboGender.Text), new MySqlParameter("@PositionPK", cboPosition.SelectedValue), new MySqlParameter("@SamaNo", txtSAMA.Text.Trim()), new MySqlParameter("@HomePhone", txtHomePhone.Text.Trim()), new MySqlParameter("@MobilePhone", txtMobilePhone.Text.Trim()), new MySqlParameter("@Email", txtEmail.Text.Trim()), new MySqlParameter("@Address", txtAddress.Text.Trim()), new MySqlParameter("@IsActive", chkIsActive.EditValue), new MySqlParameter("@CreatePK", AppVariable.CURRENT_USER_PK), new MySqlParameter("@UpdatePK", AppVariable.CURRENT_USER_PK)); CreateUser(); SqlDb.ExecuteQuery("UPDATE tblDoctor SET userPK=@UserPK WHERE doctorPK=@DoctorPK", new MySqlParameter("@DoctorPK", DocID), new MySqlParameter("@UserPK", CurUserID)); sysLogs.logsDetail(int.Parse(AppVariable.CURRENT_SUB_MENU.ToString()), "Add New Doctor."); DialogResult = MessageBox.Show("Save is successful. " + System.Environment.NewLine + "Login ID : " + loginID + System.Environment.NewLine + "Password : passw0rd" + System.Environment.NewLine + "Do you want to create new doctor?", "MediPro :: Clinic System", MessageBoxButtons.YesNo, MessageBoxIcon.Information); if (DialogResult == DialogResult.Yes) { txtName.Text = string.Empty; txtName.Tag = string.Empty; chkIsActive.EditValue = true; cboTitle.Focus(); } else { this.Close(); } } } } } } }
private void cmdSave_Click(object sender, EventArgs e) { if (ValidateForm() == true) { int SpecCnt = SqlDb.ExecuteScalar <int>("SELECT COUNT(*) FROM tblSpecialize WHERE specialize=@Specialize AND isDelete=0", new MySqlParameter("@Specialize", txtSpecialize.Text.Trim())); if (SpecCnt > 0 && cmdSave.Tag.ToString() == "Add") { MessageBox.Show("Your specialize is already exit. Please check your title.", "MediPro :: Clinic System", MessageBoxButtons.OK, MessageBoxIcon.Error); txtSpecialize.Focus(); txtSpecialize.SelectAll(); } else { if (txtSpecialize.Tag.ToString().Length > 0) { int SpecIDCnt = SqlDb.ExecuteScalar <int>("SELECT COUNT(*) FROM tblSpecialize WHERE specializePK=@SpecializePK AND isDelete=0", new MySqlParameter("@SpecializePK", txtSpecialize.Tag.ToString())); if (SpecIDCnt > 0) { SqlDb.ExecuteQuery("UPDATE tblSpecialize SET specialize=@Specialize,isActive=@IsActive,updateDate=NOW(),updatePK=@UpdatePK WHERE specializePK=@SpecializePK", new MySqlParameter("@SpecializePK", int.Parse(txtSpecialize.Tag.ToString())), new MySqlParameter("@Specialize", txtSpecialize.Text.Trim()), new MySqlParameter("@IsActive", chkIsActive.EditValue), new MySqlParameter("@updatePK", AppVariable.CURRENT_USER_PK.ToString())); sysLogs.logsDetail(int.Parse(AppVariable.CURRENT_SUB_MENU.ToString()), "Update Specialize."); MessageBox.Show("Update is successful.", "MediPro :: Clinic System", MessageBoxButtons.OK, MessageBoxIcon.Information); } } else { int SpecID = SqlDb.ExecuteScalar <int>("Call getID ('tblSpecialize')"); int SpecIDCnt = SqlDb.ExecuteScalar <int>("SELECT COUNT(*) FROM tblSpecialize WHERE specializePK=@SpecializePK AND isDelete=0", new MySqlParameter("@SpecializePK", SpecID)); if (SpecIDCnt < 1) { SqlDb.ExecuteQuery("INSERT INTO tblSpecialize(specializePK,specialize,isActive,updateDate,updatePK,createDate,createPK) " + "VALUES(@SpecializePK,@Specialize,@IsActive,NOW(),@updatePK,NOW(),@createPK)", new MySqlParameter("@SpecializePK", SpecID), new MySqlParameter("@Specialize", txtSpecialize.Text.Trim()), new MySqlParameter("@IsActive", chkIsActive.EditValue), new MySqlParameter("@updatePK", AppVariable.CURRENT_USER_PK), new MySqlParameter("@createPK", AppVariable.CURRENT_USER_PK)); sysLogs.logsDetail(int.Parse(AppVariable.CURRENT_SUB_MENU.ToString()), "Add New Specialize."); DialogResult dr = MessageBox.Show("Save is successful. Do you want to create new specialize?", "MediPro :: Clinic System", MessageBoxButtons.YesNo, MessageBoxIcon.Information); if (dr == DialogResult.Yes) { txtSpecialize.Text = string.Empty; txtSpecialize.Tag = string.Empty; chkIsActive.EditValue = true; txtSpecialize.Focus(); } else { this.Close(); } } } } } }
private void cmdSave_Click(object sender, EventArgs e) { if (ValidateForm() == true) { int PatientCnt = SqlDb.ExecuteScalar <int>("SELECT COUNT(*) FROM tblPatient WHERE RegNo=@RegNo AND isDelete=0", new MySqlParameter("@RegNo", txtRegNo.Text.Trim())); //Save image from PictureBox into MemoryStream object. MemoryStream ms = new MemoryStream(); if (null != imgPatient.Image) { imgPatient.Image.Save(ms, ImageFormat.Jpeg); } //Read from MemoryStream into Byte array. Byte[] bytImgData = new Byte[ms.Length]; ms.Position = 0; ms.Read(bytImgData, 0, Convert.ToInt32(ms.Length)); if (PatientCnt > 0) { if (txtRegNo.Text.ToString().Length > 0) { int RegNoCnt = SqlDb.ExecuteScalar <int>("SELECT COUNT(*) FROM tblPatient WHERE RegNo=@RegNo AND isDelete=0", new MySqlParameter("@RegNo", txtRegNo.Text.ToString())); if (RegNoCnt > 0) { SqlDb.ExecuteQuery("UPDATE tblPatient SET name=@Name,NRC=@NRC,titlePK=@TitlePK,FatherName=@FatherName,DOB=@DOB,Gender=@Gender,Photo=@Photo, " + "Phone=@Phone,email=@Email,Address=@Address,updateDate=NOW() WHERE RegNo=@RegNo", new MySqlParameter("@RegNo", txtRegNo.Text.Trim()), new MySqlParameter("@titlePK", cboTitle.SelectedValue), new MySqlParameter("@name", txtName.Text.Trim()), new MySqlParameter("@NRC", txtNRC.Text.Trim()), new MySqlParameter("@Gender", cboGender.Text.Trim()), new MySqlParameter("@FatherName", txtFatherName.Text.Trim()), new MySqlParameter("@DOB", dteDOB.DateTime), new MySqlParameter("@Phone", txtContactNo.Text.Trim()), new MySqlParameter("@Email", txtEmail.Text.Trim()), new MySqlParameter("@Address", txtAddress.Text.Trim()), new MySqlParameter("@Photo", MySqlDbType.VarBinary, bytImgData.Length, ParameterDirection.Input, false, 0, 0, null, DataRowVersion.Current, bytImgData), new MySqlParameter("@updatePK", AppVariable.CURRENT_USER_PK)); sysLogs.logsDetail(int.Parse(AppVariable.CURRENT_SUB_MENU.ToString()), "Update Patient Info"); MessageBox.Show("Update is successful.", "MediPro :: Clinic System", MessageBoxButtons.OK, MessageBoxIcon.Information); } } } else { DateTime dtToday = DateTime.Parse(dteRegDate.EditValue.ToString()); string strToday = dtToday.ToString("yyyy-MM-dd"); txtRegNo.Text = SqlDb.ExecuteScalar <string>("Call getRegNo (N'tblPatient','" + strToday + "')"); //int CurUserID = SqlDb.ExecuteScalar<int>("getRegNo tblPatient N'"); int RegNoCnt = SqlDb.ExecuteScalar <int>("SELECT COUNT(*) FROM tblPatient WHERE RegNo=@RegNo AND isDelete=0", new MySqlParameter("@RegNo", txtRegNo.Text.Trim())); if (RegNoCnt < 1) { SqlDb.ExecuteQuery("INSERT INTO tblPatient(RegNo,RegDate,name,Photo,NRC,titlePK,FatherName,DOB,Gender,Phone,email,Address,createPK,createDate)" + "VALUES(@RegNo,@RegDate,@Name,@Photo,@NRC,@TitlePK,@FatherName,@DOB,@Gender,@Phone,@Email,@Address,@CreatePK,NOW())", new MySqlParameter("@RegDate", dteRegDate.EditValue), new MySqlParameter("@RegNo", txtRegNo.Text.Trim()), new MySqlParameter("@name", txtName.Text.Trim()), new MySqlParameter("@Photo", MySqlDbType.VarBinary, bytImgData.Length, ParameterDirection.Input, false, 0, 0, null, DataRowVersion.Current, bytImgData), new MySqlParameter("@NRC", txtNRC.Text.Trim()), new MySqlParameter("@titlePK", cboTitle.SelectedValue), new MySqlParameter("@FatherName", txtFatherName.Text.Trim()), new MySqlParameter("@DOB", dteDOB.EditValue), new MySqlParameter("@Gender", cboGender.Text.Trim()), new MySqlParameter("@Phone", txtContactNo.Text.Trim()), new MySqlParameter("@Email", txtEmail.Text.Trim()), new MySqlParameter("@Address", txtAddress.Text.Trim()), new MySqlParameter("@CreatePK", AppVariable.CURRENT_USER_PK)); sysLogs.logsDetail(int.Parse(AppVariable.CURRENT_SUB_MENU.ToString()), "Register New Patient"); if (cmdSave.Tag.ToString() == "Booked") { SqlDb.ExecuteQuery("UPDATE tblBooking SET RegNo=@RegNo,patientName=@PatientName,isNew=1 WHERE PK=@BookingPK", new MySqlParameter("@RegNo", txtRegNo.Text.Trim()), new MySqlParameter("@PatientName", txtName.Text.Trim()), new MySqlParameter("@BookingPK", txtName.Tag.ToString())); } DialogResult dr = MessageBox.Show("Save is successful. Do you want to register new patient?", "MediPro :: Clinic System", MessageBoxButtons.YesNo, MessageBoxIcon.Information); if (dr == DialogResult.Yes) { FormClean("Add"); dteRegDate.Focus(); } else { DrawBarcode(txtName.Text, dteDOB.Text, txtRegNo.Text, imgBarcode); } } } } }