public bool Save(ShalfModel shalf) { try { var query = "INSERT INTO tbl_Shelf (Name, NumericNumber) VALUES('" + shalf.Name + "','" + shalf.NumericNumber + "')"; var rowAffected = _pharmaDb.ExecuteNonQuery(query, _connectionString); return(rowAffected > 0); } catch (Exception e) { throw new Exception(e.Message); } }
protected void btnAdd_Click(object sender, EventArgs e) { try { if (txtShalfName.Text == "" || txtShalfNumber.Text == "") { string validationMessage = "Please fillup Required fields"; lblMessage.Text = validationMessage; return; } var IsUserNameExist = _shalfManager.IsUserNameExist(txtShalfName.Text); if (IsUserNameExist) { var validationMessage = "Shalf Already Exist"; lblMessage.Text = validationMessage; return; } var IsNumberExist = _shalfManager.IsNumberExist(txtShalfNumber.Text); if (IsNumberExist) { var validationMessage = "Shalf Number Already Exist"; lblMessage.Text = validationMessage; return; } var ShalfModel = new ShalfModel(); ShalfModel.Name = txtShalfName.Text; ShalfModel.NumericNumber = txtShalfNumber.Text; var isSave = _shalfManager.Save(ShalfModel); if (isSave) { RefreshField(); string successMessage = " Saved Successfully"; lblMessage.Text = successMessage; lblMessage.ForeColor = Color.Green; return; } string failMessage = "Fild Not Saved "; lblMessage.Text = failMessage; } catch (Exception exception) { lblMessage.Text = exception.Message; } }
public ShalfModel GetByNumber(string Number) { try { var query = "SELECT * FROM tbl_Shelf WHERE NumericNumber='" + Number + "'"; var reader = _pharmaDb.ExecuteReader(query, _connectionString); if (reader.HasRows) { reader.Read(); var ShalfModel = new ShalfModel() { Name = reader["Name"].ToString(), NumericNumber = reader["NumericNumber"].ToString(), }; return(ShalfModel); } return(null); } catch (Exception e) { throw new Exception(e.Message); } }
public bool Save(ShalfModel shalf) { var save = _shalfRepository.Save(shalf); return(save); }