private void btnSave_Click(object sender, EventArgs e)
{
if (!string.IsNullOrWhiteSpace(txtUserRole.Text))
{
ComArugments args = new ComArugments();
args.ParamList[CIS.Common.User.UserRole.RoleId] = RoleId;
args.ParamList[CIS.Common.User.UserRole.RoleName] = txtUserRole.Text;
int rowsAffected = new clsLabBusinessFacade().AddUserRole(args);
if (rowsAffected > 0)
{
if (RoleId == 0)
{
MessageBox.Show("User Role is saved", "User Role", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
else
{
MessageBox.Show("User Role is updated", "User Role", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
txtUserRole.Text = string.Empty;
}
}
else
{
MessageBox.Show("Please enter User Role", "User Role", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
private void LoadData()
{
try
{
ComArugments args = new ComArugments();
args.ParamList[clsLabCommon.Laboratory.LabBillInfo.FromBillDate] = dtpFromDate.Value;
args.ParamList[clsLabCommon.Laboratory.LabBillInfo.ToBillDate] = dtpToDate.Value;
dtLabInfo = new clsLabBusinessFacade().LoadLabBillInfo(args);
dgvViewLabBills.DataSource = dtLabInfo;
dgvViewLabBills.Columns["bill_id"].Visible = false;
dgvViewLabBills.Columns["result_entry_id"].Visible = false;
//Bind Search ComboBox
DataTable dt = new DataTable();
dt.Columns.Add("HeaderType", typeof(string));
dt.Columns.Add("HeaderText", typeof(string));
foreach (DataGridViewColumn column in dgvViewLabBills.Columns)
{
if (column.Visible)
{
dt.Rows.Add(column.HeaderText, column.ValueType.Name);
}
}
cboGridHeaders.DataSource = dt;
cboGridHeaders.DisplayMember = "HeaderType";
cboGridHeaders.ValueMember = "HeaderText";
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
private void btnSave_Click(object sender, EventArgs e)
{
if (!string.IsNullOrEmpty(txtPrinterName.Text))
{
ComArugments args = new ComArugments();
args.ParamList[CIS.Common.Master.PrinterSettings.SettingId] = SettingId;
args.ParamList[CIS.Common.Master.PrinterSettings.ReportName] = cboReportName.Text;
args.ParamList[CIS.Common.Master.PrinterSettings.PrinterName] = txtPrinterName.Text;
args.ParamList[CIS.Common.Master.PrinterSettings.IsLazerPrinter] = chkIsLazer.Checked;
int rowsAffected = new clsLabBusinessFacade().AddPrinterSetting(args);
if (rowsAffected > 0)
{
if (SettingId == 0)
{
MessageBox.Show("Printer Setting is saved", "Printer Setting", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
else
{
MessageBox.Show("Printer Setting is updated", "Printer Setting", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
txtPrinterName.Text = string.Empty;
}
}
else
{
MessageBox.Show("Please enter Printer Name", "Printer Setting", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
private void btnSave_Click(object sender, EventArgs e)
{
try
{
if (ValidateControls())
{
ComArugments args = new ComArugments();
args.ParamList[CIS.Common.User.UserId] = UserId;
args.ParamList[CIS.Common.User.FullName] = txtFullName.Text;
args.ParamList[CIS.Common.User.Username] = txtUsername.Text;
args.ParamList[CIS.Common.User.Password] = new Encryption().Encrypt(txtPassword.Text, true);
args.ParamList[CIS.Common.User.UserRole.RoleId] = cboUserRole.SelectedValue;
args.ParamList[CIS.Common.User.UserType] = cboUserType.SelectedValue;
int rowsAffected = new clsLabBusinessFacade().AddEditUser(args);
if (rowsAffected > 0)
{
if (UserId == 0)
{
MessageBox.Show("User is saved", "User", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
else
{
MessageBox.Show("User is updated", "User", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
ClearControls();
}
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message + " " + ex.StackTrace);
}
}
private void btnSave_Click(object sender, EventArgs e)
{
try
{
if (dgvTestFieldsMapped.Rows.Count > 0)
{
int iDeleted = new clsLabBusinessFacade().DeleteMappedTestFields(Convert.ToInt32(cboTestItem.SelectedValue));
int order = 1;
int iSaved = 0;
foreach (DataGridViewRow row in dgvTestFieldsMapped.Rows)
{
ComArugments args = new ComArugments();
args.ParamList[clsLabCommon.Laboratory.TestFieldMapping.InvestigationId] = cboTestItem.SelectedValue;
args.ParamList[clsLabCommon.Laboratory.TestFieldMapping.TestFieldId] = row.Cells["test_field_id"].Value.ToString();
args.ParamList[clsLabCommon.Laboratory.TestFieldMapping.VisibleOrder] = order++;
iSaved = new clsLabBusinessFacade().SaveMappedTestFields(args);
}
if (iSaved > 0)
{
MessageBox.Show("Test Fields are mapped successfully", "Map Test Fields", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
else
{
MessageBox.Show("Test Fields are not selected!", "Map Test Fields", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
public int AddEditTestField(ComArugments objArg)
{
int fieldId = Convert.ToInt32(objArg.ParamList[clsLabCommon.Laboratory.TestField.TestFieldId].ToString());
string fieldName = objArg.ParamList[clsLabCommon.Laboratory.TestField.TestFieldName].ToString();
Int16 fieldTypeId = Convert.ToInt16(objArg.ParamList[clsLabCommon.Laboratory.TestField.TestFieldTypeId].ToString());
string unit = objArg.ParamList[clsLabCommon.Laboratory.TestField.Unit].ToString();
string referenceValue = objArg.ParamList[clsLabCommon.Laboratory.TestField.ReferenceValue].ToString();
if (fieldId == 0)
{
query = "INSERT INTO lab_test_field(test_field_name, test_field_type_id, unit, reference_value) " +
"VALUES ('" + fieldName + "'," + fieldTypeId + ",'" + unit + "','" + referenceValue + "')";
if (fieldTypeId == 2)
{
flag = objDBHandler.ExecuteCommandTransaction(query);
}
else
{
flag = objDBHandler.ExecuteCommand(query);
}
}
else
{
query = "UPDATE lab_test_field SET test_field_name = '" + fieldName + "',test_field_type_id =" + fieldTypeId + ", Unit ='" + unit + "', reference_value ='" + referenceValue + "'" +
"WHERE test_field_id =" + fieldId;
flag = objDBHandler.ExecuteCommand(query);
}
return(flag);
}
private void btnSave_Click(object sender, EventArgs e)
{
if (!string.IsNullOrEmpty(txtCategory.Text))
{
ComArugments args = new ComArugments();
args.ParamList[clsLabCommon.Laboratory.Category.CategoryId] = CategoryId;
args.ParamList[clsLabCommon.Laboratory.Category.CategoryName] = txtCategory.Text;
int rowsAffected = new clsLabBusinessFacade().AddCategory(args);
if (rowsAffected > 0)
{
if (CategoryId == 0)
{
MessageBox.Show("Category is saved", "Category", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
else
{
MessageBox.Show("Category is updated", "Category", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
txtCategory.Text = string.Empty;
}
}
else
{
MessageBox.Show("Please enter Category", "Category", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
public int SaveUserRoleActivity(ComArugments objArg)
{
int roleId = Convert.ToInt32(objArg.ParamList[User.UserMapRoleAction.RoleId].ToString());
int actionId = Convert.ToInt32(objArg.ParamList[User.UserMapRoleAction.ActionId].ToString());
query = "insert into cis_map_role_action(role_id,action_id) " +
"VALUES (" + roleId + "," + actionId + ")";
flag = objDBHandler.ExecuteCommand(query);
return(flag);
}
private void btnSave_Click(object sender, EventArgs e)
{
try
{
if (!string.IsNullOrWhiteSpace(txtFieldName.Text))
{
ComArugments args = new ComArugments();
args.ParamList[clsLabCommon.Laboratory.TestField.TestFieldId] = FieldId;
args.ParamList[clsLabCommon.Laboratory.TestField.TestFieldName] = txtFieldName.Text.Replace("'", "''");
args.ParamList[clsLabCommon.Laboratory.TestField.TestFieldTypeId] = cboFieldType.SelectedValue;
args.ParamList[clsLabCommon.Laboratory.TestField.Unit] = txtUnit.Text.Replace("'", "''");;
args.ParamList[clsLabCommon.Laboratory.TestField.ReferenceValue] = rtxtReferenceValue.Text.Replace("'", "''");
int rowsAffected = objBusinessFacade.AddEditTestField(args);
if (rowsAffected > 0)
{
if (cboFieldType.Text.Equals("ComboBox"))
{
int lastInsertedFieldId = 0;
if (FieldId == 0)
{
lastInsertedFieldId = objBusinessFacade.getLastInsertedId();
}
for (int i = 0; i < dgvTestItem.Rows.Count - 1; i++)
{
ComArugments argsTestItems = new ComArugments();
argsTestItems.ParamList[clsLabCommon.Laboratory.TestItem.TestItemId] = dgvTestItem.Rows[i].Cells["Id"].FormattedValue.ToString() == "" ? 0 : dgvTestItem.Rows[i].Cells["Id"].FormattedValue;
argsTestItems.ParamList[clsLabCommon.Laboratory.TestItem.TestItemName] = dgvTestItem.Rows[i].Cells["Item"].Value;
argsTestItems.ParamList[clsLabCommon.Laboratory.TestItem.TestFieldId] = FieldId == 0 ? lastInsertedFieldId : FieldId;
int flag = objBusinessFacade.AddEditTestItems(argsTestItems);
}
}
if (FieldId == 0)
{
MessageBox.Show("Test Field is saved", "Test Field", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
else
{
MessageBox.Show("Test Field is updated", "Test Field", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
ClearControls();
}
objBusinessFacade.commitTransction();
}
else
{
MessageBox.Show("Please enter Test Field", "Test Field", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message + " " + ex.StackTrace);
}
}
public int SaveMappedTestFields(ComArugments objArg)
{
int investigationId = Convert.ToInt32(objArg.ParamList[clsLabCommon.Laboratory.TestFieldMapping.InvestigationId].ToString());
string testfieldId = objArg.ParamList[clsLabCommon.Laboratory.TestFieldMapping.TestFieldId].ToString();
int visibleOrder = Convert.ToInt32(objArg.ParamList[clsLabCommon.Laboratory.TestFieldMapping.VisibleOrder].ToString());
query = "insert into lab_test_field_mapping(investigation_id,test_field_id,visible_order) " +
"VALUES (" + investigationId + ",'" + testfieldId + "'," + visibleOrder + ")";
flag = objDBHandler.ExecuteCommand(query);
return(flag);
}
public int SaveResultEntryDetailInfo(ComArugments objArg)
{
int resultEntryId = Convert.ToInt32(objArg.ParamList[clsLabCommon.Laboratory.TestResultEntry.ResultEntryId].ToString());
int investigationId = Convert.ToInt32(objArg.ParamList[clsLabCommon.Laboratory.TestResultEntry.InvestigationId].ToString());
int fieldId = Convert.ToInt32(objArg.ParamList[clsLabCommon.Laboratory.TestResultEntry.TestFieldId].ToString());
string resultValue = objArg.ParamList[clsLabCommon.Laboratory.TestResultEntry.ResultValue].ToString();
query = "insert into lab_test_result_detail_entry (result_entry_id, investigation_id,test_field_id,result_value) " +
"values (" + resultEntryId + "," + investigationId + "," + fieldId + ",'" + resultValue + "')";
flag = objDBHandler.ExecuteCommand(query);
return(flag);
}
public int AddUserRole(ComArugments objArg)
{
int roleId = Convert.ToInt32(objArg.ParamList[User.UserRole.RoleId].ToString());
string userRole = objArg.ParamList[User.UserRole.RoleName].ToString();
if (roleId == 0)
{
query = "INSERT INTO cis_roles(role_name) VALUES ('" + userRole + "')";
}
else
{
query = "UPDATE cis_roles SET role_name = '" + userRole + "' WHERE role_id =" + roleId;
}
flag = objDBHandler.ExecuteCommand(query);
return(flag);
}
public int AddCategory(ComArugments objArg)
{
int categoryId = Convert.ToInt32(objArg.ParamList[clsLabCommon.Laboratory.Category.CategoryId].ToString());
string category = objArg.ParamList[clsLabCommon.Laboratory.Category.CategoryName].ToString();
if (categoryId == 0)
{
query = "INSERT INTO LAB_CATEGORY(category_name) VALUES ('" + category + "')";
}
else
{
query = "UPDATE LAB_CATEGORY SET category_name = '" + category + "' WHERE category_id =" + categoryId;
}
flag = objDBHandler.ExecuteCommand(query);
return(flag);
}
public int AddPrinterSetting(ComArugments objArg)
{
int settingId = Convert.ToInt32(objArg.ParamList[Master.PrinterSettings.SettingId].ToString());
string reportName = objArg.ParamList[Master.PrinterSettings.ReportName].ToString();
string printerName = objArg.ParamList[Master.PrinterSettings.PrinterName].ToString();
bool isLazerPrinter = Convert.ToBoolean(objArg.ParamList[Master.PrinterSettings.IsLazerPrinter].ToString());
if (settingId == 0)
{
query = "INSERT INTO printer_settings(report_name,printer_name,is_lazer_printer) VALUES ('" + reportName + "','" + printerName + "'," + isLazerPrinter + ")";
}
else
{
query = "UPDATE printer_settings SET report_name = '" + reportName + "',printer_name='" + printerName + "',is_lazer_printer =" + isLazerPrinter + " WHERE setting_id =" + settingId;
}
flag = objDBHandler.ExecuteCommand(query);
return(flag);
}
private void LoadCorporateDueList()
{
try
{
ComArugments args = new ComArugments();
args.ParamList["startDate"] = dtpFromDate.Value.ToString("yyyyMMdd" + "000000");
args.ParamList["endDate"] = dtpToDate.Value.ToString("yyyyMMdd" + "235959");
args.ParamList["corporateId"] = cboCorporate.SelectedValue;
dtCorporateDue = new CIS.BusinessFacade.BusinessFacade().CorporateDueListDetails(args);
dgvCorporateDueList.DataSource = dtCorporateDue;
string due = dtCorporateDue.Compute("sum(due)", string.Empty).ToString();
lblTotalDue.Text = due;
lblRemainingDue.Text = due;
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
public int AddEditTestItems(ComArugments objArg)
{
int itemId = Convert.ToInt32(objArg.ParamList[clsLabCommon.Laboratory.TestItem.TestItemId].ToString());
string itemName = objArg.ParamList[clsLabCommon.Laboratory.TestItem.TestItemName].ToString();
int fieldId = Convert.ToInt32(objArg.ParamList[clsLabCommon.Laboratory.TestField.TestFieldId].ToString());
if (itemId == 0)
{
query = "INSERT INTO lab_test_item(test_item_name, test_field_id) " +
"VALUES ('" + itemName + "'," + fieldId + ")";
}
else
{
query = "UPDATE lab_test_item SET test_item_name = '" + itemName + "',test_field_id =" + fieldId +
" WHERE test_item_id =" + itemId;
}
flag = objDBHandler.ExecuteCommand(query);
return(flag);
}
public DataTable LoadLabBillInfo(ComArugments objArg)
{
string fromBillDate = CommonUtility.GetMySQLDateTime((objArg.ParamList[clsLabCommon.Laboratory.LabBillInfo.FromBillDate].ToString()), DateDataType.DateNoFormatBegin);
string toBillDate = Convert.ToDateTime(objArg.ParamList[clsLabCommon.Laboratory.LabBillInfo.ToBillDate].ToString()).ToString("yyyyMMdd" + "235959");
query = @"select
bi.bill_id,
bill_number as 'Bill Number',
patient_id as 'Patient Id',
visit_number as 'Visit Number',
patient_name as 'Patient Name',
if(gender = 1, 'Female', 'Male') as 'Gender',
age_year as 'Age', result_entry_id,
date_format(bill_date, '%d/%m/%Y %h:%i %p') as 'Bill Date'
from
inv_bill_info bi
left join lab_test_result_entry re ON re.bill_id = bi.bill_id
where bill_date between " + fromBillDate + " and " + toBillDate +
" order by bill_date desc";
dtSource = objDBHandler.ExecuteTable(query);
return(dtSource);
}
public int AddEditUser(ComArugments objArg)
{
int userId = Convert.ToInt32(objArg.ParamList[User.UserId].ToString());
string fullName = objArg.ParamList[User.FullName].ToString();
string username = objArg.ParamList[User.Username].ToString();
string password = objArg.ParamList[User.Password].ToString();
int roleId = Convert.ToInt32(objArg.ParamList[User.UserRole.RoleId].ToString());
int userTypeId = Convert.ToInt32(objArg.ParamList[User.UserType].ToString());
int status = 1; //Active Users
if (userId == 0)
{
query = "INSERT INTO cis_user(full_name,user_name,password,user_type,status,user_role_id) " +
" VALUES ('" + fullName + "','" + username + "','" + password + "'," + userTypeId + "," + status + "," + roleId + ")";
}
else
{
query = "UPDATE cis_user SET full_name = '" + fullName + "', user_name = '" + username + "', password = '******', user_role_id =" + roleId + " ,status =" + status + " ,user_type =" + userTypeId + " WHERE user_id =" + userId;
}
flag = objDBHandler.ExecuteCommand(query);
return(flag);
}
public int SaveResultEntryInfo(ComArugments objArg)
{
int resultEntryId = Convert.ToInt32(objArg.ParamList[clsLabCommon.Laboratory.TestResultEntry.ResultEntryId].ToString());
int billId = Convert.ToInt32(objArg.ParamList[clsLabCommon.Laboratory.TestResultEntry.BillId].ToString());
string receivedDateTime = Convert.ToDateTime(objArg.ParamList[clsLabCommon.Laboratory.TestResultEntry.ReceivedDateTime].ToString()).ToString("yyyy-MM-dd hh:mm:ss");
string reportedDateTime = Convert.ToDateTime(objArg.ParamList[clsLabCommon.Laboratory.TestResultEntry.ReportedDateTime].ToString()).ToString("yyyy-MM-dd hh:mm:ss");
if (resultEntryId == 0)
{
query = "insert into lab_test_result_entry(bill_id,received_date_time,reported_date_time) " +
"values (" + billId + ",'" + receivedDateTime + "','" + reportedDateTime + "')";
}
else
{
query = "update lab_test_result_entry set bill_id = " + billId + ",received_date_time = '" + receivedDateTime + "',reported_date_time='" + reportedDateTime + "' "
+ "where result_entry_id=" + resultEntryId;
}
flag = objDBHandler.ExecuteCommandTransaction(query);
if (resultEntryId == 0)
{
flag = getLastInsertedId();
}
return(flag);
}
public int AddCategory(ComArugments args)
{
return(new clsLabDataAccess().AddCategory(args));
}
public int SaveDischargeSummary(ComArugments args)
{
return(new clsLabDataAccess().SaveDischargeSummary(args));
}
public int AddPrinterSetting(ComArugments args)
{
return(new clsLabDataAccess().AddPrinterSetting(args));
}
public int SaveUserRoleActivity(ComArugments args)
{
return(objDataAccess.SaveUserRoleActivity(args));
}
public int AddEditUser(ComArugments args)
{
return(new clsLabDataAccess().AddEditUser(args));
}
public int AddUserRole(ComArugments args)
{
return(new clsLabDataAccess().AddUserRole(args));
}
public DataTable LoadLabBillInfo(ComArugments comArgs)
{
return(new clsLabDataAccess().LoadLabBillInfo(comArgs));
}
public int SaveResultEntryDetailInfo(ComArugments args)
{
return(objDataAccess.SaveResultEntryDetailInfo(args));
}
public int AddEditTestField(ComArugments args)
{
return(objDataAccess.AddEditTestField(args));
}
public int AddEditTestItems(ComArugments args)
{
return(objDataAccess.AddEditTestItems(args));
}
public int SaveMappedTestFields(ComArugments comArgs)
{
return(new clsLabDataAccess().SaveMappedTestFields(comArgs));
}
