public string SaveMedicine(StockMedicine aStockMedicine)
{
if (aMedicineGateway.SaveMedicine(aStockMedicine) > 0)
{
return("Saved Successfully");
}
else
{
return("Failed");
}
}
public int SaveMedicine(StockMedicine aStockMedicine)
{
SqlConnection connection = new SqlConnection(connectionString);
string query = " INSERT INTO CenterMedicineRelationTBL VALUES ('" + aStockMedicine.CenterId + "', '" + aStockMedicine.MedicineId + "', '" + aStockMedicine.Quantaty + "') ";
SqlCommand aCommand = new SqlCommand(query, connection);
connection.Open();
int rowAffedted = aCommand.ExecuteNonQuery();
connection.Close();
return(rowAffedted);
}
public bool UpdateStockMedicine(StockMedicine stockMedicine)
{
try
{
dbContext.Update <StockMedicine>(stockMedicine);
dbContext.SaveChanges();
return(true);
}
catch (Exception ex)
{
return(false);
}
}
protected void saveButton_Click(object sender, EventArgs e)
{
DataTable DTab = (DataTable)ViewState["Medicine"];
foreach (DataRow dr in DTab.Rows)
{
StockMedicine aStockMedicine = new StockMedicine();
aStockMedicine.ThanaId = int.Parse(ddlThana.SelectedValue);
aStockMedicine.CenterId = int.Parse(ddlCenter.SelectedValue);
aStockMedicine.MedicineId = int.Parse(dr["id"].ToString().Trim());
aStockMedicine.Quantaty = int.Parse(dr["Quantaty"].ToString().Trim());
msgLabel.Text = aMedicineManager.SaveMedicine(aStockMedicine);
}
}
