public static List <DrugDetails> GetAll()
{
List <DrugDetails> lstStore = new List <DrugDetails>();
object[] value = null;
var connection = new SQLCommand(ConstValue.ConnectionString);
var result = connection.Select("DrugDetails_Getall", value);
if (connection.errorCode == 0 && result.Rows.Count > 0)
{
foreach (DataRow dr in result.Rows)
{
DrugDetails store = new DrugDetails()
{
id = int.Parse(dr["id"].ToString()),
drugname = dr["drugname"].ToString(),
price = int.Parse(dr["price"].ToString()),
note = dr["note"].ToString(),
iddrugstore = int.Parse(dr["iddrugstore"].ToString())
};
lstStore.Add(store);
}
}
return(lstStore);
}
public List <DrugDetails> GetDrugList(string ClientName, string CriteriaType)
{
List <DrugDetails> _ddList = new List <DrugDetails>();
_cmd = new SqlCommand($"select * from [dbo].[ADFeedSelectionCriteriaLookup] where Delivery = '{ClientName}' and CriteriaType = '{CriteriaType}'", _conn);
try
{
_conn.Open();
SqlDataReader reader = _cmd.ExecuteReader();
while (reader.Read())
{
DrugDetails dd = new DrugDetails();
dd.Delivery = reader[0].ToString();
dd.CriteriaType = reader[1].ToString();
dd.Criteria = reader[2].ToString();
dd.IsActive = Convert.ToInt32(reader[4]);
if (reader[3].Equals(System.DBNull.Value))
{
dd.TermID = null;
}
else
{
dd.TermID = Convert.ToInt32(reader[3]);
}
if (reader[5].Equals(System.DBNull.Value))
{
dd.ModificationDate = null;
}
else
{
dd.ModificationDate = Convert.ToDateTime(reader[5]);
}
if (reader[6].Equals(System.DBNull.Value))
{
dd.CreationDate = null;
}
else
{
dd.CreationDate = Convert.ToDateTime(reader[6]);
}
_ddList.Add(dd);
}
}
catch (Exception)
{
UserFriendlyMessage.setMessage("Exception while fetching the Drug List");
throw;
}
finally
{
_conn.Close();
_cmd.Dispose();
}
return(_ddList);
}
public IActionResult DeleteDrugCategory(int id)
{
object[] value = { id };
var errorCode = 0;
var errorMessage = "";
string[] output = { };
DrugDetails store = DetailDrugStoreRes.GetAll().Where(i => i.id == id).FirstOrDefault();
var result = DetailDrugStoreRes.DeleteDetailDrugStore(value, ref output, ref errorCode, ref errorMessage);
return(RedirectToAction("DetailDrugStore", new { @id = store.iddrugstore }));
}
/// <summary>
/// Drug search
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void lstDrugSearch_SelectionChanged(object sender, SelectionChangedEventArgs e)
{
selectedData = (sender as ListBox).SelectedItem as DrugDetails;
_isSearchDone = true;
if (selectedData != null)
{
prescription = new Prescription();
if (!string.IsNullOrEmpty(selectedData.amp))
{
prescription.amp = selectedData.amp;
}
else
{
prescription.amp = string.Empty;
}
if (!string.IsNullOrEmpty(selectedData.ampp))
{
prescription.ampp = selectedData.ampp;
}
else
{
prescription.ampp = string.Empty;
}
tbxDrugSearch.Text = selectedData.drugname;
if (!string.IsNullOrEmpty(selectedData.vmp))
{
prescription.vmp = selectedData.vmp;
}
else
{
prescription.vmp = string.Empty;
}
if (!string.IsNullOrEmpty(selectedData.vmpp))
{
prescription.vmpp = selectedData.vmpp;
}
else
{
prescription.vmpp = string.Empty;
}
PopupSearch.IsOpen = false;
}
else
{
PopupSearch.IsOpen = true;
}
}
public async Task <IActionResult> PostAsync([FromBody] DrugDetails drugDetails)
{
string filePath = @"c:\FileData\Filedata.txt";;
var result = await _couchRepository.WriteTextAsync(filePath, drugDetails);
if (result.Length > 0)
{
// var sResult = JsonConvert.DeserializeObject<SavedResult>(result.SuccessContentObject);
return(Ok(result));
}
return(BadRequest());
}
public List <DrugDetails> Get()
{
var reader = this.GetReader("select * from DrugDetails");
var drugDetails = new List <DrugDetails>();
while (reader.Read())
{
var drugDetail = new DrugDetails();
drugDetail.DrugId = reader.GetInt32(0);
drugDetail.DrugName = reader.GetString(1);
drugDetail.DrugDescription = reader.GetString(2);
drugDetails.Add(drugDetail);
}
return(drugDetails);
}
/// <summary>
/// This method responsible for returing the Drug Details searched by Drug ID and Location
/// </summary>
/// <param name="drugId"></param>
/// <param name="location"></param>
/// <returns></returns>
public virtual IEnumerable <DrugLocation> GetDispatchableDrugStock(int drugId, string location)
{
List <DrugLocation> item = new List <DrugLocation>();
DrugDetails drug = new DrugDetails();
var obj1 = DrugRepository.ls;
for (int i = 0; i < ls.Count; i++)
{
if (list[i].Drug_Id == drugId && list[i].Location == location)
{
item.Add(list[i]);
}
}
return(item);
}
public IEnumerable <DrugLocation> getDispatchableDrugStock(int Id, string location)
{
var obj = DrugLocController.list;
List <DrugLocation> item = new List <DrugLocation>();
DrugDetails drug = new DrugDetails();
var obj1 = Drug.ls;
for (int i = 0; i < ls.Count; i++)
{
if (list[i].Drug_Id == Id && list[i].Location == location)
{
item.Add(list[i]);
}
}
return(item);
}
/// <summary>
/// Search drugs when text input
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private async void acbDrugSearch_TextChanged(object sender, RoutedEventArgs e)
{
var folder = ApplicationData.Current.LocalFolder.GetFolderAsync("DataFolder");
try
{
SQLiteAsyncConnection conn = new SQLiteAsyncConnection(Path.Combine(ApplicationData.Current.LocalFolder.Path, "DataFile.sqlite"), true);
string pillname = acbDrugSearch.Text;
if (!string.IsNullOrEmpty(pillname) && !string.IsNullOrWhiteSpace(pillname) && pillname.Length > 3)
{
var query = conn.Table <drugs>().Where(x => x.drugname.Contains(pillname));
var result = await query.ToListAsync();
if (result == null)
{
MessageBox.Show("Pill not found.");
}
else
{
List <DrugDetails> druglist = new List <DrugDetails>();
foreach (var item in result)
{
DrugDetails dataRead = new DrugDetails();
dataRead._id = item._id;
dataRead.amp = item.amp;
dataRead.ampp = item.ampp;
dataRead.drug_code = item.drug_code;
dataRead.drugform = item.drugform;
dataRead.strenght = item.strenght;
dataRead.drugname = string.Format("{0} {1}", item.drugname, dataRead.strenght);
dataRead.size = item.size;
dataRead.strenght = item.strenght;
dataRead.vmp = item.vmp;
dataRead.vmpp = item.vmpp;
druglist.Add(dataRead);
}
lstDrugSearch.ItemsSource = druglist;
}
}
}
catch (Exception ex)
{
}
}
public async Task <IActionResult> PostAsync([FromBody] DrugDetails drugDetails)
{
_logger.LogInformation("writing to text file data {0} {1}", drugDetails.DrugName, drugDetails.DrugExpiredOn, drugDetails.LotNo);
_logger.LogTrace("writing to text file data {0} {1}", drugDetails.DrugName, drugDetails.DrugExpiredOn, drugDetails.LotNo);
string filePath = @"c:\FileData\Filedata.txt";;
var result = await _couchRepository.WriteTextAsync(filePath, drugDetails);
if (result.Length > 0)
{
_logger.LogInformation("data written to file sucessfully");
_logger.LogTrace("data written to file sucessfully");
return(Ok(result));
}
return(BadRequest());
}
protected void RadButton1_Click(object sender, EventArgs e)
{
IPediatric PediatricManager;
PediatricManager = (IPediatric)ObjectFactory.CreateInstance("BusinessProcess.Pharmacy.BPediatric, BusinessProcess.Pharmacy");
List <IPharmacyFields> PharmacyList = new List <IPharmacyFields>();
IPharmacyFields objPharmacyFields = new IPharmacyFields();
List <DrugDetails> objlist = new List <DrugDetails>();
DrugDetails objDetails = new DrugDetails();
objPharmacyFields.Ptn_pk = Convert.ToInt32(Request.QueryString["PatientID"]);
objPharmacyFields.LocationID = Int32.Parse(Session["AppLocationId"].ToString());
objPharmacyFields.userid = Int32.Parse(Session["AppUserId"].ToString());
objPharmacyFields.ptn_pharmacy_pk = 0;
if (PharmWeight.Text != "")
{
objPharmacyFields.Weight = Convert.ToDecimal(PharmWeight.Text);
}
if (PharmHeight.Text != "")
{
objPharmacyFields.Height = Convert.ToDecimal(PharmHeight.Text);
}
if (ddregimenline.SelectedItem.Value.ToString() != "")
{
objPharmacyFields.RegimenLine = Convert.ToInt32(ddregimenline.SelectedItem.Value);
}
objPharmacyFields.PharmacyRefillDate = DateGiven(appdate.SelectedDate.ToString());
if (PharmNotes.Text != "")
{
objPharmacyFields.PharmacyNotes = PharmNotes.Text;
}
if (rcbprescribed.SelectedItem.Value != "")
{
objPharmacyFields.OrderedBy = Convert.ToInt32(rcbprescribed.SelectedItem.Value);
}
if (prescribedbydate.SelectedDate.ToString() != "")
{
objPharmacyFields.OrderedByDate = DateGiven(prescribedbydate.SelectedDate.ToString());
}
if (rcbdispensed.SelectedItem.Value.ToString() != "")
{
objPharmacyFields.DispensedBy = Convert.ToInt32(rcbdispensed.SelectedItem.Value.ToString());
}
if (dispensedbydate.SelectedDate.ToString() != "")
{
objPharmacyFields.DispensedByDate = DateGiven(dispensedbydate.SelectedDate.ToString());
}
foreach (GridNestedViewItem nestedView in rgdrugmain.MasterTableView.GetItems(GridItemType.NestedView))
{
RadGrid gridOrdersGrid = (RadGrid)nestedView.FindControl("OrdersGrid");
DataTable dtupdateOrder = (DataTable)ViewState["TableOrder"];
foreach (GridDataItem item in gridOrdersGrid.Items)
{
string drugID = item.GetDataKeyValue("DrugID").ToString();
RadTextBox txtdose = (RadTextBox)item.FindControl("txtDose");
RadComboBox ddlfrequency = (RadComboBox)item.FindControl("rdcmbfrequency");
RadTextBox txtduration = (RadTextBox)item.FindControl("txtDuration");
RadTextBox txtqtyprec = (RadTextBox)item.FindControl("txtQtyPrescribed");
CheckBox chkProphylaxis = (CheckBox)item.FindControl("chkProphylaxis");
RadTextBox txtnooffile = (RadTextBox)item.FindControl("txtRefill");
for (int i = 0; i < dtupdateOrder.Rows.Count; i++)
{
if (dtupdateOrder.Rows[i]["DrugID"].ToString() == drugID)
{
objDetails.GenericId = Convert.ToInt32(dtupdateOrder.Rows[i]["GenericID"].ToString());
if (txtdose.Text != "")
{
dtupdateOrder.Rows[i]["Dose"] = Convert.ToDecimal(txtdose.Text);
objDetails.SingleDose = Convert.ToDecimal(txtdose.Text);
}
if (ddlfrequency.SelectedItem.Value.ToString() != "")
{
dtupdateOrder.Rows[i]["Frequency"] = Convert.ToInt32(ddlfrequency.SelectedItem.Value);
objDetails.FrequencyID = Convert.ToInt32(ddlfrequency.SelectedItem.Value);;
}
if (txtduration.Text != "")
{
dtupdateOrder.Rows[i]["Duration"] = Convert.ToDecimal(txtduration.Text);
objDetails.Duration = Convert.ToDecimal(txtduration.Text);
}
if (txtqtyprec.Text != "")
{
dtupdateOrder.Rows[i]["QtyPrescribed"] = Convert.ToDecimal(txtqtyprec.Text);
objDetails.OrderedQuantity = Convert.ToDecimal(txtqtyprec.Text);
}
dtupdateOrder.Rows[i]["Prophylaxis"] = Convert.ToInt32(chkProphylaxis.Checked);
if (txtnooffile.Text != "")
{
dtupdateOrder.Rows[i]["Refill"] = Convert.ToInt32(txtnooffile.Text);
}
dtupdateOrder.AcceptChanges();
}
}
}
ViewState["TableOrder"] = dtupdateOrder;
RadGrid gridDispense = (RadGrid)nestedView.FindControl("Dispense");
DataTable dtDispense = (DataTable)ViewState["TableDispense"];
foreach (GridDataItem item in gridDispense.Items)
{
string drugID = item.GetDataKeyValue("DrugID").ToString();
RadComboBox ddlbatch = (RadComboBox)item.FindControl("rdcmbbatch");
RadTextBox txtqtydispensed = (RadTextBox)item.FindControl("txtQtyDispensed");
RadTextBox txtsellingprice = (RadTextBox)item.FindControl("txtSellingPrice");
RadTextBox txtbillamt = (RadTextBox)item.FindControl("txtBillAmount");
for (int i = 0; i < dtDispense.Rows.Count; i++)
{
if (dtDispense.Rows[i]["DrugID"].ToString() == drugID)
{
if (ddlbatch.SelectedItem.Value.ToString() != "")
{
dtDispense.Rows[i]["Batch"] = Convert.ToInt32(ddlbatch.SelectedItem.Value);
objDetails.BatchNo = Convert.ToInt32(ddlbatch.SelectedItem.Value);
}
if (txtqtydispensed.Text != "")
{
dtDispense.Rows[i]["QtyDispensed"] = Convert.ToDecimal(txtqtydispensed.Text);
objDetails.DispensedQuantity = Convert.ToDecimal(txtqtydispensed.Text);
}
if (txtsellingprice.Text != "")
{
dtDispense.Rows[i]["SellingPrice"] = Convert.ToDecimal(txtsellingprice.Text);
}
if (txtbillamt.Text != "")
{
dtDispense.Rows[i]["BillAmount"] = Convert.ToDecimal(txtbillamt.Text);
}
}
}
}
ViewState["TableDispense"] = dtDispense;
objlist.Add(objDetails);
}
objPharmacyFields.Druginfo = objlist;
PharmacyList.Add(objPharmacyFields);
//int result = PediatricManager.SaveUpdatePharmacyTouch(PharmacyList);
}
public void Add(DrugDetails drugDetail)
{
this.ExecuteNonQuery($"insert into DrugDetails values ('{drugDetail.DrugName}','{drugDetail.DrugDescription}')");
}
public void Update(DrugDetails drugDetail)
{
this.ExecuteNonQuery($"update DrugDetails set DrugName='{drugDetail.DrugName},DrugDescription='{drugDetail.DrugDescription}'");
}
public IActionResult Post(DrugDetails drugDetail)
{
drugDetailDomain.Add(drugDetail);
return(Ok());
}
public async Task <Result <GetPatientPharmacyResponse> > Handle(GetPatientPharmacyDetailsCommand request, CancellationToken cancellationToken)
{
using (_pharmunitOfWork)
{
try
{
//StringBuilder sql = new StringBuilder();
//sql.Append($"select * from [dbo].[PharmacyDrugVisitDetailsView] where PatientMasterVisitId='{request.PatientMasterVisitId }'");
/* StringBuilder sqldel = new StringBuilder();
* sqldel.Append("[dbo].[pr_Pharmacy_GetExistPharmacyDrugVisitDetails] @PatientMasterVisitId");
* var patientmastervisitid = new SqlParameter();
* patientmastervisitid.SqlDbType = SqlDbType.Int;
* patientmastervisitid.ParameterName = "@PatientMasterVisitId";
* patientmastervisitid.Size = -1;
* patientmastervisitid.Value = Convert.ToInt32(request.PatientMasterVisitId); */
//var patientmastervisitid = new SqlParameter("@PatientMasterVisitId", request.PatientMasterVisitId);
/* var pharmacyvisit = await _pharmunitOfWork.Repository<PharmacyDrugVisitDetails>().FromSql(sqldel.ToString(), parameters: new[] {
* patientmastervisitid
* });*/
var pharmacyorder = await _pharmunitOfWork.Repository <PatientPharmacyOrder>().Get(x => x.PatientMasterVisitId == request.PatientMasterVisitId).ToListAsync();
if (pharmacyorder.Count > 0)
{
dispensedDate = pharmacyorder[0].DispensedByDate;
orderedDate = pharmacyorder[0].OrderedbyDate;
StringBuilder sql = new StringBuilder();
sql.Append($"SELECT [Visit_Id],[Ptn_Pk],[LocationID],[VisitDate], Convert(Int,[VisitType]) as VisitType, DataQuality,[DeleteFlag],[UserID] ,[CreateDate] ,[CreatedBy] FROM [dbo].[ord_Visit] where Visit_Id='{pharmacyorder[0].VisitId}' and (DeleteFlag is null or DeleteFlag=0) ");
var visit = await _pharmunitOfWork.Repository <PatientVisit>().FromSql(sql.ToString());
if (visit != null)
{
if (visit.Count > 0)
{
visitDate = visit[0].VisitDate;
}
}
foreach (var phar in pharmacyorder)
{
StringBuilder sqlptn = new StringBuilder();
sqlptn.Append($"select * from PharmacyDrugVisitDetailsView where ptn_pharmacy_pk='{phar.ptn_pharmacy_pk}'");
var pharmacylist = _pharmunitOfWork.Repository <PharmacyDrugVisitDetails>().Get(x => x.ptn_pharmacy_pk == phar.ptn_pharmacy_pk).ToList();
if (pharmacylist != null)
{
if (pharmacylist.Count > 0)
{
pharmacylist.ForEach(x =>
{
DrugDetails pds = new DrugDetails();
pds.ptn_pharmacy_pk = x.ptn_pharmacy_pk;
pds.DrugName = x.DrugName;
pds.DrugId = Convert.ToString(x.Drug_pk);
pds.DrugAbb = x.Abbreviation;
pds.batchId = Convert.ToString(x.BatchNo);
pds.batchText = x.BatchName;
pds.Dose = Convert.ToString(x.SingleDose);
pds.Freq = Convert.ToString(x.FrequencyID);
pds.FreqText = x.FrequencyName;
pds.Duration = Convert.ToString(x.Duration);
pds.QUantityDisp = Convert.ToString(x.DispensedQuantity);
pds.QuantityPres = Convert.ToString(x.OrderedQuantity);
pds.Reason = Convert.ToString(x.TreatmentPlanReasonId);
pds.ReasonText = Convert.ToString(x.TreatmentPlanReason);
pds.Regimen = Convert.ToString(x.RegimenId);
pds.Regimentext = Convert.ToString(x.Regimen);
pds.Regimenline = Convert.ToString(x.RegimenLineId);
pds.Regimenlinetext = Convert.ToString(x.RegimenLine);
pds.TreatmentPlan = Convert.ToString(x.TreatmentPlan);
pds.TreatmentPlantext = Convert.ToString(x.TreatmentPlanText);
pds.TreatmentProgram = Convert.ToString(x.ProgID);
pds.TreatmentProgramText = Convert.ToString(x.TreatmentProgram);
pds.Morning = Convert.ToString(x.MorningDose);
pds.Evening = Convert.ToString(x.EveningDose);
pds.Night = Convert.ToString(x.EveningDose);
pds.Midday = Convert.ToString(x.MiddayDose);
pds.Night = Convert.ToString(x.NightDose);
pds.Period = Convert.ToString(x.PeriodTaken);
pds.PeriodTakentext = Convert.ToString(x.PeriodTakenText);
pds.Prophylaxis = Convert.ToString(x.Prophylaxis);
presc.Add(pds);
});
}
}
}
}
// var pharmacylist = await _pharmunitOfWork.Repository<PharmacyDrugVisitDetails>().GetAllAsync();
//var pharmacyvisit = pharmacylist.Where(x => x.PatientMasterVisitId == request.PatientMasterVisitId && x.ptn_pharmacy_pk.ToString() == "156872").ToList();
//var pharmacyvisit = await _pharmunitOfWork.Repository<PharmacyDrugVisitDetails>().FromSql(sql.ToString());
/* if (pharmacyvisit.Count > 0)
* {
*
* dispensedDate = pharmacyvisit[0].DispensedByDate;
* orderedDate = pharmacyvisit[0].OrderedByDate;
* visitDate = pharmacyvisit[0].VisitDate;
*
* pharmacyvisit.ForEach( x =>
* {
* DrugDetails pds = new DrugDetails();
* pds.ptn_pharmacy_pk = x.ptn_pharmacy_pk;
* pds.DrugName = x.DrugName;
* pds.DrugId = Convert.ToString(x.Drug_pk);
* pds.DrugAbb = x.Abbreviation;
* pds.batchId = Convert.ToString(x.BatchNo);
* pds.batchText = x.BatchName;
* pds.Dose = Convert.ToString(x.SingleDose);
* pds.Freq = Convert.ToString(x.FrequencyID);
* pds.FreqText = x.FrequencyName;
* pds.Duration = Convert.ToString(x.Duration);
* pds.QUantityDisp = Convert.ToString(x.DispensedQuantity);
* pds.QuantityPres = Convert.ToString(x.OrderedQuantity);
* pds.Reason = Convert.ToString(x.TreatmentPlanReasonId);
* pds.ReasonText = Convert.ToString(x.TreatmentPlanReason);
* pds.Regimen = Convert.ToString(x.RegimenId);
* pds.Regimentext = Convert.ToString(x.Regimen);
* pds.Regimenline = Convert.ToString(x.RegimenLineId);
* pds.Regimenlinetext = Convert.ToString(x.RegimenLine);
* pds.TreatmentPlan = Convert.ToString(x.TreatmentPlan);
* pds.TreatmentPlantext = Convert.ToString(x.TreatmentPlanText);
* pds.TreatmentProgram = Convert.ToString(x.ProgID);
* pds.TreatmentProgramText = Convert.ToString(x.TreatmentProgram);
* pds.Morning = Convert.ToString(x.MorningDose);
* pds.Evening = Convert.ToString(x.EveningDose);
* pds.Night = Convert.ToString(x.EveningDose);
* pds.Midday = Convert.ToString(x.MiddayDose);
* pds.Night = Convert.ToString(x.NightDose);
* pds.Period = Convert.ToString(x.PeriodTaken);
* pds.PeriodTakentext = Convert.ToString(x.PeriodTakenText);
* pds.Prophylaxis = Convert.ToString(x.Prophylaxis);
*
* presc.Add(pds);
* });
*
*
*
* }*/
return(Result <GetPatientPharmacyResponse> .Valid(new GetPatientPharmacyResponse()
{
PatientMasterVisitId = request.PatientMasterVisitId,
PatientId = request.PatientId,
DispensedDate = dispensedDate,
VisitDate = visitDate,
OrderedByDate = orderedDate,
DrugDetails = presc
}));
}
catch (Exception ex)
{
return(Result <GetPatientPharmacyResponse> .Invalid("Error getting the drug records for this visit " + ex.Message));
}
}
}
public IActionResult Put(DrugDetails drugDetail)
{
drugDetailDomain.Update(drugDetail);
return(Ok());
}
public ActionResult GetdetailDrugStore(int id)
{
DEntity <DrugDetails> e = new DEntity <DrugDetails>(ConstValue.ConnectionString, DrugDetails.getTableName());
return(Json(e.get("id", id)));
}
