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