public void Add(LkpMedicineType lkpMedicineType)
{
List <SqlParameter> lstSqlParameter = new List <SqlParameter>();
lstSqlParameter.Add(new SqlParameter("@medicineType", lkpMedicineType.MedicineType));
lstSqlParameter.Add(new SqlParameter("@medicineTypeDesc", lkpMedicineType.MedicineTypeDesc));
SqlHelper.ExecuteStoredProcedure(StoredProcedureConstants.LkpMedicineType.ADDLKPMEDICINETYPEPRC, lstSqlParameter);
}
protected void btnSave_Click(object sender, EventArgs e)
{
LkpMedicineType lkpMedicineType = new LkpMedicineType();
lkpMedicineType.MedicineType = txtMedicineType.Text;
lkpMedicineType.MedicineTypeDesc = txtMedicineTypeDesc.Text;
lkpMedicineTypeManager.Add(lkpMedicineType);
BindLkpMedicineTypeGrid();
ResetControls();
}
public LkpMedicineType GetById(int id)
{
List <SqlParameter> lstSqlParameter = new List <SqlParameter>();
lstSqlParameter.Add(new SqlParameter("@lkpMedicineType", id));
ds = SqlHelper.ExecuteStoredProcedure(StoredProcedureConstants.LkpMedicineType.GETLKPMEDICINETYPEPRC, lstSqlParameter, "LkpMedicineType");
LkpMedicineType lkpMedicineType = new LkpMedicineType();
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
{
lkpMedicineType.Id = Convert.ToInt32(ds.Tables[0].Rows[i]["Id"]);
lkpMedicineType.MedicineType = Convert.ToString(ds.Tables[0].Rows[i]["MedicineType"]);
lkpMedicineType.MedicineTypeDesc = Convert.ToString(ds.Tables[0].Rows[i]["MedicineTypeDesc"]);
}
return(lkpMedicineType);
}
public List <LkpMedicineType> GetAll()
{
ds = SqlHelper.ExecuteStoredProcedure(StoredProcedureConstants.LkpMedicineType.GETLKPMEDICINETYPEPRC);
List <LkpMedicineType> lstLkpMedicineType = new List <LkpMedicineType>();
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
{
LkpMedicineType lkpMedicineType = new LkpMedicineType();
lkpMedicineType.Id = Convert.ToInt32(ds.Tables[0].Rows[i]["Id"]);
lkpMedicineType.MedicineType = Convert.ToString(ds.Tables[0].Rows[i]["MedicineType"]);
lkpMedicineType.MedicineTypeDesc = Convert.ToString(ds.Tables[0].Rows[i]["MedicineTypeDesc"]);
lstLkpMedicineType.Add(lkpMedicineType);
}
return(lstLkpMedicineType);
}
protected void grvMedicineType_RowUpdating(object sender, GridViewUpdateEventArgs e)
{
int medicineTypeId = Convert.ToInt32(grvMedicineType.DataKeys[e.RowIndex].Value.ToString());
GridViewRow row = (GridViewRow)grvMedicineType.Rows[e.RowIndex];
TextBox textMedicineType = (TextBox)row.Cells[1].Controls[0];
TextBox textMedicineTypeDesc = (TextBox)row.Cells[2].Controls[0];
LkpMedicineType lkpMedicineType = new LkpMedicineType();
lkpMedicineType.Id = medicineTypeId;
lkpMedicineType.MedicineType = textMedicineType.Text;
lkpMedicineType.MedicineTypeDesc = textMedicineTypeDesc.Text;
lkpMedicineTypeManager.Update(lkpMedicineType);
grvMedicineType.EditIndex = -1;
BindLkpMedicineTypeGrid();
}
public void Update(LkpMedicineType lkpMedicineType)
{
lkpMedicineTypeService.Update(lkpMedicineType);
}
public void Add(LkpMedicineType lkpMedicineType)
{
lkpMedicineTypeService.Add(lkpMedicineType);
}
