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