public object UpdateHcMedicineInfo(object param) { Database db = DatabaseFactory.CreateDatabase(); object retObj = null; using (DbConnection connection = db.CreateConnection()) { connection.Open(); DbTransaction transaction = connection.BeginTransaction(); try { HcMedicineEntity hcMedicineEntity = (HcMedicineEntity)param; HcMedicineDAL hcMedicineDAL = new HcMedicineDAL(); retObj = (object)hcMedicineDAL.UpdateHcMedicineInfo(hcMedicineEntity, db, transaction); transaction.Commit(); } catch { transaction.Rollback(); throw; } finally { connection.Close(); } } return(retObj); }
public DataTable GetAllHcMedicineRecord(object param) { Database db = DatabaseFactory.CreateDatabase(); string sql = ""; HcMedicineEntity obj = new HcMedicineEntity(); if (param != null) { obj = (HcMedicineEntity)param; } if (obj.FullView) { sql = @" SELECT A.ID, A.MedicineName, A.MedicineCompany,A.ImageUrl, A.MedicineDesc, A.MedicineType, B.MedicineTypeName, A.ProductCategory,C.categoryName, A.MedicinePrice, A.MedicineImage, A.UoM, A.StockQnty, A.CreatedBy, A.CreatedAt, A.UpdateBy, A.UpdatedAt, A.Status FROM HC_Medicine A , HC_MedicineType B , HC_ProductCategory C where 1=1 And A.Status = 'Active' and A.MedicineType = B.ID and A.ProductCategory = C.ID"; } else { sql = @" SELECT A.ID, A.MedicineName, A.MedicineCompany,A.ImageUrl, A.MedicineDesc, A.MedicineType, B.MedicineTypeName, A.ProductCategory,C.categoryName, A.MedicinePrice, A.MedicineImage, A.UoM, A.StockQnty, A.CreatedBy, A.CreatedAt, A.UpdateBy, A.UpdatedAt, A.Status FROM HC_Medicine A , HC_MedicineType B , HC_ProductCategory C where 1=1 And A.Status = 'Active' and A.MedicineType = B.ID and A.ProductCategory = C.ID"; } if (!string.IsNullOrEmpty(obj.Id)) { sql += " And A.ID = '" + obj.Id + "'"; } if (!string.IsNullOrEmpty(obj.Medicinetype)) { sql += " And A.MedicineType = '" + obj.Medicinetype + "'"; } if (!string.IsNullOrEmpty(obj.Medicinecompany)) { sql += " And A.MedicineCompany Like '%" + obj.Medicinecompany + "%'"; } if (!string.IsNullOrEmpty(obj.Productcategory)) { sql += " And A.ProductCategory = '" + obj.Productcategory + "'"; } sql += " Order by A.MedicineName Asc"; DbCommand dbCommand = db.GetSqlStringCommand(sql); DataSet ds = db.ExecuteDataSet(dbCommand); return(ds.Tables[0]); }
string getAllMedicine(string ispromo) { string MedicineData = ""; HcMedicineEntity iGet = new HcMedicineEntity(); iGet.FullView = true; iGet.ispromo = ispromo; string noImage = "/Docx/no_image.png"; // = "1"; DataTable dt = (DataTable)ExecuteDB(HCareTaks.AG_GetAllHcMedicineRecord, iGet); if (dt.Rows.Count > 0) { foreach (DataRow dpm in dt.Rows) { string medicineimage = string.IsNullOrEmpty(dpm["ImageUrl"].ToString()) ? noImage : dpm["ImageUrl"].ToString(); MedicineData += @"<div class='card custome-card' style='background-color: #ffffff' >" + "<a href = '/Home/Medicine/" + dpm["ID"] + "' target='_blank'>" + "<img class='card-img-top display_img' src='" + medicineimage + "' alt='Medicin imagae'/>" + "<div class='card-body'>" + "<div class='row'>" + "<div class='col-md-12 col-lg-12'>" + "<h3> " + dpm["Medicineprice"] + "</h3>" + "<p class='card-title'> " + dpm["Medicinename"] + "</p>" + " <span class='badge badge-pill badge-primary'> <small>" + dpm["UoM"] + "</small> </span>" + " <span class='badge badge-pill badge-secondary'> <small>" + dpm["Medicinetypename"] + "</small> </span>" + " <span class='badge badge-pill badge-info'> <small>" + dpm["categoryName"] + "</small> </span>" + "<p class='card-text text-truncate'> " + dpm["Medicinecompany"] + "</p>" + "</div>" + "</a>" + "<div class='btn-group d-flex' role='group'>" + " <span type='label' class='btn btn-default w-100'>Buy</span>" + "<button type='button' class='btn btn-default w-100'>-</button>" + "<button type='button' class='btn btn-default w-100'>+</button>" + "</div>" + "</div>" + "</div>" + "</div>"; } } return(MedicineData); }
public bool SaveHcMedicineInfo(HcMedicineEntity hcMedicineEntity, Database db, DbTransaction transaction) { string sql = "INSERT INTO HC_Medicine ( MedicineName, MedicineCompany, MedicineType, ProductCategory, MedicinePrice, MedicineImage, UoM, StockQnty, CreatedBy, CreatedAt, UpdateBy, UpdatedAt, Status) VALUES ( @Medicinename, @Medicinecompany, @Medicinetype, @Productcategory, @Medicineprice, @Medicineimage, @Uom, @Stockqnty, @Createdby, @Createdat, @Updateby, @Updatedat, @Status )"; DbCommand dbCommand = db.GetSqlStringCommand(sql); db.AddInParameter(dbCommand, "Medicinename", DbType.String, hcMedicineEntity.Medicinename); db.AddInParameter(dbCommand, "Medicinecompany", DbType.String, hcMedicineEntity.Medicinecompany); db.AddInParameter(dbCommand, "Medicinetype", DbType.String, hcMedicineEntity.Medicinetype); db.AddInParameter(dbCommand, "Productcategory", DbType.String, hcMedicineEntity.Productcategory); db.AddInParameter(dbCommand, "Medicineprice", DbType.String, hcMedicineEntity.Medicineprice); db.AddInParameter(dbCommand, "Medicineimage", DbType.String, hcMedicineEntity.Medicineimage); db.AddInParameter(dbCommand, "Uom", DbType.String, hcMedicineEntity.Uom); db.AddInParameter(dbCommand, "Stockqnty", DbType.String, hcMedicineEntity.Stockqnty); db.AddInParameter(dbCommand, "Createdby", DbType.String, hcMedicineEntity.Createdby); db.AddInParameter(dbCommand, "Createdat", DbType.String, hcMedicineEntity.Createdat); db.AddInParameter(dbCommand, "Updateby", DbType.String, hcMedicineEntity.Updateby); db.AddInParameter(dbCommand, "Updatedat", DbType.String, hcMedicineEntity.Updatedat); db.AddInParameter(dbCommand, "Status", DbType.String, hcMedicineEntity.Status); db.ExecuteNonQuery(dbCommand, transaction); return(true); }
public bool UpdateHcMedicineInfo(HcMedicineEntity hcMedicineEntity, Database db, DbTransaction transaction) { string sql = "UPDATE HC_Medicine SET MedicineName= @Medicinename, MedicineCompany= @Medicinecompany, MedicineType= @Medicinetype, ProductCategory= @Productcategory, MedicinePrice= @Medicineprice, MedicineImage= @Medicineimage, UoM= @Uom, StockQnty= @Stockqnty, CreatedBy= @Createdby, CreatedAt= @Createdat, UpdateBy= @Updateby, UpdatedAt= @Updatedat, Status= @Status WHERE Id=@Id"; DbCommand dbCommand = db.GetSqlStringCommand(sql); db.AddInParameter(dbCommand, "Id", DbType.String, hcMedicineEntity.Id); db.AddInParameter(dbCommand, "Medicinename", DbType.String, hcMedicineEntity.Medicinename); db.AddInParameter(dbCommand, "Medicinecompany", DbType.String, hcMedicineEntity.Medicinecompany); db.AddInParameter(dbCommand, "Medicinetype", DbType.String, hcMedicineEntity.Medicinetype); db.AddInParameter(dbCommand, "Productcategory", DbType.String, hcMedicineEntity.Productcategory); db.AddInParameter(dbCommand, "Medicineprice", DbType.String, hcMedicineEntity.Medicineprice); db.AddInParameter(dbCommand, "Medicineimage", DbType.String, hcMedicineEntity.Medicineimage); db.AddInParameter(dbCommand, "Uom", DbType.String, hcMedicineEntity.Uom); db.AddInParameter(dbCommand, "Stockqnty", DbType.String, hcMedicineEntity.Stockqnty); db.AddInParameter(dbCommand, "Createdby", DbType.String, hcMedicineEntity.Createdby); db.AddInParameter(dbCommand, "Createdat", DbType.String, hcMedicineEntity.Createdat); db.AddInParameter(dbCommand, "Updateby", DbType.String, hcMedicineEntity.Updateby); db.AddInParameter(dbCommand, "Updatedat", DbType.String, hcMedicineEntity.Updatedat); db.AddInParameter(dbCommand, "Status", DbType.String, hcMedicineEntity.Status); db.ExecuteNonQuery(dbCommand, transaction); return(true); }
public HcMedicineEntity GetSingleHcMedicineRecordById(object param) { Database db = DatabaseFactory.CreateDatabase(); string sql = "SELECT ID, MedicineName, MedicineCompany, MedicineType, ProductCategory, MedicinePrice, MedicineImage, UoM, StockQnty, CreatedBy, CreatedAt, UpdateBy, UpdatedAt, Status FROM HC_Medicine WHERE Id=@Id"; DbCommand dbCommand = db.GetSqlStringCommand(sql); db.AddInParameter(dbCommand, "Id", DbType.String, param); HcMedicineEntity hcMedicineEntity = null; using (IDataReader dataReader = db.ExecuteReader(dbCommand)) { if (dataReader.Read()) { hcMedicineEntity = new HcMedicineEntity(); if (dataReader["ID"] != DBNull.Value) { hcMedicineEntity.Id = dataReader["ID"].ToString(); } if (dataReader["MedicineName"] != DBNull.Value) { hcMedicineEntity.Medicinename = dataReader["MedicineName"].ToString(); } if (dataReader["MedicineCompany"] != DBNull.Value) { hcMedicineEntity.Medicinecompany = dataReader["MedicineCompany"].ToString(); } if (dataReader["MedicineType"] != DBNull.Value) { hcMedicineEntity.Medicinetype = dataReader["MedicineType"].ToString(); } if (dataReader["ProductCategory"] != DBNull.Value) { hcMedicineEntity.Productcategory = dataReader["ProductCategory"].ToString(); } if (dataReader["MedicinePrice"] != DBNull.Value) { hcMedicineEntity.Medicineprice = dataReader["MedicinePrice"].ToString(); } if (dataReader["MedicineImage"] != DBNull.Value) { hcMedicineEntity.Medicineimage = dataReader["MedicineImage"].ToString(); } if (dataReader["UoM"] != DBNull.Value) { hcMedicineEntity.Uom = dataReader["UoM"].ToString(); } if (dataReader["StockQnty"] != DBNull.Value) { hcMedicineEntity.Stockqnty = dataReader["StockQnty"].ToString(); } if (dataReader["CreatedBy"] != DBNull.Value) { hcMedicineEntity.Createdby = dataReader["CreatedBy"].ToString(); } if (dataReader["CreatedAt"] != DBNull.Value) { hcMedicineEntity.Createdat = dataReader["CreatedAt"].ToString(); } if (dataReader["UpdateBy"] != DBNull.Value) { hcMedicineEntity.Updateby = dataReader["UpdateBy"].ToString(); } if (dataReader["UpdatedAt"] != DBNull.Value) { hcMedicineEntity.Updatedat = dataReader["UpdatedAt"].ToString(); } if (dataReader["Status"] != DBNull.Value) { hcMedicineEntity.Status = dataReader["Status"].ToString(); } } } return(hcMedicineEntity); }