public List<Remark> GetAll() { List<Remark> remarks = new List<Remark>(); try { SqlConnectionObj.Open(); string query = String.Format("Select * From tbl_Remark"); SqlCommandObj.CommandText = query; SqlDataReader dataReader = SqlCommandObj.ExecuteReader(); while (dataReader.Read()) { Remark aRemark = new Remark(); aRemark.Id = Convert.ToInt32(dataReader["ID"]); aRemark.Name = dataReader["Name"].ToString(); remarks.Add(aRemark); } } catch(Exception ex) { throw new Exception("Remarks can not loaded from your system",ex); } finally { if (SqlCommandObj !=null && SqlConnectionObj.State==ConnectionState.Open) { SqlConnectionObj.Close(); } } return remarks; }
public Remark GetRemark(int remarkId) { try { SqlConnectionObj.Open(); string query = string.Format("Select * From tbl_Remark where ID = " + remarkId); SqlCommandObj.CommandText = query; SqlDataReader dataReader = SqlCommandObj.ExecuteReader(); Remark aRemark = new Remark(); while (dataReader.Read()) { aRemark.Id = Convert.ToInt32(dataReader["ID"]); aRemark.Name = dataReader["Name"].ToString(); } return aRemark; } catch (Exception ex) { throw new Exception("Remarks can not loaded from your system", ex); } finally { if (SqlCommandObj != null && SqlConnectionObj.State == ConnectionState.Open) { SqlConnectionObj.Close(); } } }
public bool Save(Remark aRemark, out string saveMessage) { if (aRemark.Name == string.Empty) { saveMessage = "Remark data is missing"; return false; } else if (remarkGateway.HasThisRemarkName(aRemark.Name)) { saveMessage = "Your system already has this remark data. Try again."; return false; } else { saveMessage = "Remark has been saved."; return remarkGateway.Save(aRemark); } }
public bool Save(Remark remark) { try {SqlConnectionObj.Open(); string query = string.Format("Insert into tbl_Remark values('{0}')", remark.Name); SqlCommandObj.CommandText = query; SqlCommandObj.ExecuteNonQuery(); } catch (Exception ex) { throw new Exception("Remark couldn't saved", ex); } finally { if (SqlConnectionObj != null && SqlConnectionObj.State == ConnectionState.Open) { SqlConnectionObj.Close(); } } return true; }