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