public void SaveInvoiceHeader()
{
try
{
MySqlCommand sqlcmd = new MySqlCommand();
sqlcmd.CommandText = "INSERT INTO `medipro`.`tbllabinvoice`(`labInvoiceNo`,`doctorPK`,`invoiceDate`,`branchPK`,`patientPK`,`totalAmount`,`deposit`,`discount`,`paidAmount`,`changeAmount`,`netAmount`,`createPK`,`createDate`,`updatePK`,`updateDate`)VALUES(@labInvoiceNo,@doctorPK,@invoiceDate,@branchPK,@patientPK,@totalAmount,@deposit,@discount,@paidAmount,@changeAmount,@netAmount,@createPK,@createDate,@updatePK,@updateDate);";
sqlcmd.Parameters.AddWithValue("@labInvoiceNo", invoiceNo);
sqlcmd.Parameters.AddWithValue("@doctorPK", doctorPK);
sqlcmd.Parameters.AddWithValue("@invoiceDate", invoiceDate);
sqlcmd.Parameters.AddWithValue("@branchPK", branchPK);
sqlcmd.Parameters.AddWithValue("@patientPK", patientPK);
sqlcmd.Parameters.AddWithValue("@totalAmount", totalAmount);
sqlcmd.Parameters.AddWithValue("@deposit", deposit);
sqlcmd.Parameters.AddWithValue("@discount", discount);
sqlcmd.Parameters.AddWithValue("@paidAmount", paidAmount);
sqlcmd.Parameters.AddWithValue("@changeAmount", changeAmount);
sqlcmd.Parameters.AddWithValue("@netAmount", netAmount);
sqlcmd.Parameters.AddWithValue("@createPK", AppVariable.CURRENT_USER_PK);
sqlcmd.Parameters.AddWithValue("@createDate", DateTime.Now);
sqlcmd.Parameters.AddWithValue("@updatePK", AppVariable.CURRENT_USER_PK);
sqlcmd.Parameters.AddWithValue("@updateDate", DateTime.Now);
SqlDb.ExecuteQuery(sqlcmd);
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
}
}
void Save()
{
calcTokenNoAndBookingTime();
string BookingID = SqlDb.ExecuteScalar <string>("getBookingPK N'tblBooking','" + dtBoooking.ToString("yyyy-MM-dd") + "'");
int bookingCnt = SqlDb.ExecuteScalar <int>("SELECT COUNT(*) FROM tblBooking WHERE bookingPK = @BookingPK",
new MySqlParameter("@BookingPK", BookingID));
if (bookingCnt < 1)
{
SqlDb.ExecuteQuery("UPDATE tblBooking SET isLast = 0 WHERE doctorPK = @DoctorPK AND isLast = 1 AND abdate = @abDate",
new MySqlParameter("@DoctorPK", doctorPK),
new MySqlParameter("@abDate", dtBoooking.Date.ToString("yyyy-MM-dd")));
SqlDb.ExecuteQuery("INSERT INTO tblBooking(PK,patientName,RegNo,abdate,doctorPK,tokenNo,abTime,abType,isNew,isLast) " +
"VALUES(@PK,@PatientName,@RegNo,@ABDate,@DoctorPK,@TokenNo,@ABTime,@ABType,@IsNew,@IsLast)",
new MySqlParameter("@PK", BookingID),
new MySqlParameter("@PatientName", (radioNewPatient.Checked == true) ? txtPatientName.Text.Trim() : luePatient.Text.ToString()),
new MySqlParameter("@RegNo", (radioNewPatient.Checked == true) ? string.Empty : txtRegNo.Text.ToString()),
new MySqlParameter("@ABDate", dtBoooking.Date.ToString("yyyy-MM-dd")),
new MySqlParameter("@DoctorPK", doctorPK),
new MySqlParameter("@TokenNo", lblTokenNo.Text),
new MySqlParameter("@ABTime", lblLastBookingTime.Text),
new MySqlParameter("@ABType", "Booking"),
new MySqlParameter("@IsNew", (radioNewPatient.Checked == true) ? 0 : 1),
new MySqlParameter("@IsLast", 1));
MessageBox.Show("Booking is Successfull." + System.Environment.NewLine + "Token No. is : " + lblTokenNo.Text + System.Environment.NewLine + "Time is : " + lblLastBookingTime.Text, "MediPro::Clinic System", MessageBoxButtons.OK, MessageBoxIcon.Information);
this.Close();
}
}
public static void logs_login()
{
SqlDb.ExecuteQuery("INSERT INTO sys_log(LogInID,WhichFunction,Description,LogDateTime) " +
"VALUES(@LogInID,@WhichFunction,@Description,NOW())",
new MySqlParameter("@LogInID", AppVariable.CURRENT_USER_PK),
new MySqlParameter("@WhichFunction", "Login"),
new MySqlParameter("@Description", "Login"));
}
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 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 cmdSave_Click(object sender, EventArgs e)
{
SqlDb.ExecuteQuery("UPDATE sysMainMenuDefine SET IsView=@IsView WHERE mainmenuPK = @MainMenuPK AND levelPK = @LevelPK",
new MySqlParameter("@MainMenuPK", CurMainMenuID),
new MySqlParameter("@LevelPK", CurLevelID),
new MySqlParameter("@IsView", chkMainMenuView.EditValue));
for (int i = 0; i < grdViewSubMenu.RowCount; i++)
{
SqlDb.ExecuteQuery("UPDATE sysLevelDefine SET dataView = @DataView , dataInsert = @DataInsert , dataEdit = @DataEdit , dataDelete = @DataDelete WHERE PK = @PK",
new MySqlParameter("@DataView", (grdViewSubMenu.GetRowCellDisplayText(i, "dataView").ToString() == "Checked") ? true : false),
new MySqlParameter("@DataInsert", (grdViewSubMenu.GetRowCellDisplayText(i, "dataInsert").ToString() == "Checked") ? true : false),
new MySqlParameter("@DataEdit", (grdViewSubMenu.GetRowCellDisplayText(i, "dataEdit").ToString() == "Checked") ? true : false),
new MySqlParameter("@DataDelete", (grdViewSubMenu.GetRowCellDisplayText(i, "dataDelete").ToString() == "Checked") ? true : false),
new MySqlParameter("@PK", grdViewSubMenu.GetRowCellDisplayText(i, "PK").ToString()));
}
DialogResult = MessageBox.Show("Save is successful.", "MediPro :: Clinic System", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
private void btnDelete_Click(object sender, EventArgs e)
{
if (grdViewMedicine.RowCount > 0)
{
DialogResult dr = MessageBox.Show("Are you sure you want to delete this medicine?", "MediPro :: Clinic System", MessageBoxButtons.YesNo, MessageBoxIcon.Information);
if (dr == DialogResult.Yes)
{
SqlDb.ExecuteQuery("DELETE FROM tblPackList WHERE medPK=" + drMedicine.ItemArray[0].ToString());
SqlDb.ExecuteQuery("UPDATE tblMedicine SET isDelete=1 WHERE medPK=" + drMedicine.ItemArray[0].ToString());
BindingMedicine();
if (grdViewMedicine.RowCount > 0)
{
drMedicine = grdViewMedicine.GetDataRow(grdViewMedicine.FocusedRowHandle);
}
}
}
}
private void cmdSave_Click(object sender, EventArgs e)
{
bool IsValid = false;
string strErrMsg = "";
//if (txtSampleID.Text.Length > 0)
//{
// int DupCnt = SqlDb.ExecuteScalar<int>("SELECT COUNT(*) FROM sysRoles WHERE isDelete=0 AND roleName='" + txtRoleName.Text + "' AND rolePK<>" + intLabTechReqPK.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";
//}
IsValid = true;
if (IsValid)
{
if (intLabTechReqPK == 0)
{
SqlDb.ExecuteQuery("update tbllabtechnicianrequest set " +
"hasSample = @hasSample , sampleID = @sampleID, " +
"sampleDateTime = @sampleDateTime , updatePK = @updatePK, updateDate = now() " +
"where labtechnicianrequestPK = @labtechnicianrequestPK",
new MySqlParameter("@hasSample", chkHasSample.EditValue),
new MySqlParameter("@sampleID", txtSampleID.Text.Trim()),
new MySqlParameter("@sampleDateTime", dteSampleDate.DateTime.ToString("yyyy-MM-dd")),
new MySqlParameter("@updatePK", AppVariable.CURRENT_USER_PK),
new MySqlParameter("@labtechnicianrequestPK", intLabTechReqPK));
}
}
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 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);
}
}
}
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 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 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 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 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 = "";
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 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)
{
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);
}
}
}
}
}
