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);
}
}
}
}
}
