public List <MedicineQuantity> GetdicineQuantities()
{
List <MedicineQuantity> medicines = new List <MedicineQuantity>();
SqlConnection connection = new SqlConnection(connectionstring);
string query = "SELECT * FROM Table_MedicineQuantity";
SqlCommand command = new SqlCommand(query, connection);
connection.Open();
SqlDataReader reader = command.ExecuteReader();
while (reader.Read())
{
MedicineQuantity medicine = new MedicineQuantity();
medicine.Id = int.Parse(reader["medicineQuantity_Id"].ToString());
medicine.Name = reader["medicineQuantity_Name"].ToString();
medicine.Quantity = int.Parse(reader["medicineQuantity_Quantity"].ToString());
medicine.CenterId = int.Parse(reader["medicineQuantity_CenterId"].ToString());
medicines.Add(medicine);
}
return(medicines);
}
public string InsertMedicineQunatity(MedicineQuantity medicineQuantity)
{
int value = centerGateway.MedicineQuantityEntry(medicineQuantity);
if (value > 0)
{
return("medicine quantity saved successfully");
}
else
{
return("Operation Failed");
}
}
public int SaveMedicineQuantity(MedicineQuantity medicineQuantity)
{
SqlConnection connection = new SqlConnection(connectionString);
string query = "INSERT INTO DistributeMedicine VALUES('" + medicineQuantity.CenterId + "','" + medicineQuantity.MedicineId + "','" + medicineQuantity.Quantity + "')";
SqlCommand command = new SqlCommand(query, connection);
connection.Open();
int rowsAffected = command.ExecuteNonQuery();
connection.Close();
return(rowsAffected);
}
public int MedicineQuantityEntry(MedicineQuantity medicineQuantity)
{
SqlConnection connection = new SqlConnection(connectionstring);
string query = "INSERT INTO Table_MedicineQuantity VALUES('" + medicineQuantity.Name + "','" + medicineQuantity.Quantity + "','" + medicineQuantity.CenterId + "')";
SqlCommand command = new SqlCommand(query, connection);
connection.Open();
int rowsAffected = command.ExecuteNonQuery();
connection.Close();
return(rowsAffected);
}
public void Add(MedicineQuantity medicineQuantity)
{
List <SqlParameter> lstSqlParameter = new List <SqlParameter>();
lstSqlParameter.Add(new SqlParameter("@dateOfPurchase", medicineQuantity.DateOfPurchase));
lstSqlParameter.Add(new SqlParameter("@expiryDate", medicineQuantity.ExpiryDate));
lstSqlParameter.Add(new SqlParameter("@manfactureDate", medicineQuantity.ManfactureDate));
lstSqlParameter.Add(new SqlParameter("@price", medicineQuantity.Price));
lstSqlParameter.Add(new SqlParameter("@medQuantity", medicineQuantity.MedQuantity));
lstSqlParameter.Add(new SqlParameter("@createdDate", DateTime.Now));
lstSqlParameter.Add(new SqlParameter("@createdUserId", medicineQuantity.CreatedUserId));
lstSqlParameter.Add(new SqlParameter("@medicineId", medicineQuantity.MedicineId));
SqlHelper.ExecuteStoredProcedure(StoredProcedureConstants.MedicineQuantity.ADDMEDICINEQUANTITYPRC, lstSqlParameter);
}
public MedicineQuantity GetById(int id)
{
List <SqlParameter> lstSqlParameter = new List <SqlParameter>();
lstSqlParameter.Add(new SqlParameter("@medicineQuantity", id));
ds = SqlHelper.ExecuteStoredProcedure(StoredProcedureConstants.MedicineQuantity.GETMEDICINEQUANTITYPRC, lstSqlParameter, "MedicineQuantity");
MedicineQuantity medicineQuantity = new MedicineQuantity();
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
{
medicineQuantity.QuantityId = Convert.ToInt32(ds.Tables[0].Rows[i]["QuantityId"]);
medicineQuantity.DateOfPurchase = Convert.ToDateTime(ds.Tables[0].Rows[i]["DateOfPurchase"]);
medicineQuantity.ExpiryDate = Convert.ToDateTime(ds.Tables[0].Rows[i]["ExpiryDate"]);
medicineQuantity.ManfactureDate = Convert.ToDateTime(ds.Tables[0].Rows[i]["ManfactureDate"]);
medicineQuantity.Price = Convert.ToInt32(ds.Tables[0].Rows[i]["Price"]);
medicineQuantity.MedQuantity = Convert.ToInt32(ds.Tables[0].Rows[i]["MedQuantity"]);
medicineQuantity.MedicineId = Convert.ToInt32(ds.Tables[0].Rows[i]["MedicineId"]);
}
return(medicineQuantity);
}
public List <MedicineQuantity> GetAll()
{
ds = SqlHelper.ExecuteStoredProcedure(StoredProcedureConstants.MedicineQuantity.GETMEDICINEQUANTITYPRC);
List <MedicineQuantity> lstMedicineQuantity = new List <MedicineQuantity>();
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
{
MedicineQuantity medicineQuantity = new MedicineQuantity();
medicineQuantity.QuantityId = Convert.ToInt32(ds.Tables[0].Rows[i]["QuantityId"]);
medicineQuantity.DateOfPurchase = Convert.ToDateTime(ds.Tables[0].Rows[i]["DateOfPurchase"]);
medicineQuantity.ExpiryDate = Convert.ToDateTime(ds.Tables[0].Rows[i]["ExpiryDate"]);
medicineQuantity.ManfactureDate = Convert.ToDateTime(ds.Tables[0].Rows[i]["ManfactureDate"]);
medicineQuantity.Price = Convert.ToInt32(ds.Tables[0].Rows[i]["Price"]);
medicineQuantity.MedQuantity = Convert.ToInt32(ds.Tables[0].Rows[i]["MedQuantity"]);
medicineQuantity.MedicineId = Convert.ToInt32(ds.Tables[0].Rows[i]["MedicineId"]);
medicineQuantity.MedicineName = Convert.ToString(ds.Tables[0].Rows[i]["MedicineName"]);
lstMedicineQuantity.Add(medicineQuantity);
}
return(lstMedicineQuantity);
}
public void Update(MedicineQuantity medicineQuantity)
{
medicineQuantityService.Update(medicineQuantity);
}
public void Add(MedicineQuantity medicineQuantity)
{
medicineQuantityService.Add(medicineQuantity);
}
public int SaveMedicineQuantity(MedicineQuantity medicineQuantity)
{
return(gateway.SaveMedicineQuantity(medicineQuantity));
}
