public Designation GetDesignation(int designationId) { try { SqlConnectionObj.Open(); string query = String.Format("SELECT * FROM tbl_Designation WHERE Id='{0}'", designationId); SqlCommandObj.CommandText = query; SqlDataReader reader = SqlCommandObj.ExecuteReader(); Designation aDesignation = new Designation(); while (reader.Read()) { aDesignation.Id = Convert.ToInt32(reader["Id"]); aDesignation.Code = reader["Code"].ToString(); aDesignation.Title = reader["Title"].ToString(); } return aDesignation; } catch (Exception ex) { throw new Exception("Designation couldn't loaded from your system", ex); } finally { if (SqlConnectionObj != null && SqlConnectionObj.State == ConnectionState.Open) { SqlConnectionObj.Close(); } } }
public bool Save(Designation aDesignation, out string saveMessage) { if (aDesignation.Code == string.Empty) { saveMessage = "Designation code missing"; return false; } else if (aDesignation.Title == string.Empty) { saveMessage = "Designation title missing"; return false; } else if (designationGateway.HasThisDesignationCode(aDesignation.Code)) { saveMessage = "Your system already has this designation code. Try again."; return false; } else if (designationGateway.HasThisDesignationTitle(aDesignation.Title)) { saveMessage = "Your system already has this designation title. Try again."; return false; } else { saveMessage = "Designation has been saved."; return designationGateway.Save(aDesignation); } }
public List<Designation> GetAll() { List<Designation> designations = new List<Designation>(); try { SqlConnectionObj.Open(); string query = String.Format("SELECT * FROM tbl_Designation"); SqlCommandObj.CommandText = query; SqlDataReader readerObj = SqlCommandObj.ExecuteReader(); while (readerObj.Read()) { Designation aDesignation = new Designation(); aDesignation.Id = Convert.ToInt32(readerObj["Id"]); aDesignation.Code = readerObj["Code"].ToString(); aDesignation.Title = readerObj["Title"].ToString(); designations.Add(aDesignation); } } catch (Exception ex) { throw new Exception("Designation couldn't loaded from your system", ex); } finally { if (SqlConnectionObj != null && SqlConnectionObj.State == ConnectionState.Open) { SqlConnectionObj.Close(); } } return designations; }
public Designation GetDesignation(int designationId) { SqlConnectionObj.Open(); string query = String.Format("SELECT * FROM tbl_Designation WHERE Id='{0}'", designationId); SqlCommandObj.CommandText = query; SqlDataReader reader = SqlCommandObj.ExecuteReader(); Designation aDesignation = new Designation(); while (reader.Read()) { aDesignation.Id = Convert.ToInt32(reader["Id"]); aDesignation.Code = reader["Code"].ToString(); aDesignation.Title = reader["Title"].ToString(); } SqlConnectionObj.Close(); return aDesignation; }
public List<Designation> GetAll() { List<Designation> designations = new List<Designation>(); SqlConnectionObj.Open(); string query = String.Format("SELECT * FROM tbl_Designation"); SqlCommandObj.CommandText = query; SqlDataReader readerObj = SqlCommandObj.ExecuteReader(); while (readerObj.Read()) { Designation aDesignation = new Designation(); aDesignation.Id = Convert.ToInt32(readerObj["Id"]); aDesignation.Code = readerObj["Code"].ToString(); aDesignation.Title = readerObj["Title"].ToString(); designations.Add(aDesignation); } SqlConnectionObj.Close(); return designations; }
public bool Save(Designation aDesignation) { try { SqlConnectionObj.Open(); string query = String.Format("INSERT INTO tbl_Designation VALUES('{0}','{1}')", aDesignation.Code, aDesignation.Title); SqlCommandObj.CommandText = query; SqlCommandObj.ExecuteNonQuery(); } catch (Exception ex) { throw new Exception("Designation couldn't saved",ex); } finally { if (SqlConnectionObj != null && SqlConnectionObj.State == ConnectionState.Open) { SqlConnectionObj.Close(); } } return true; }
public bool Save(Designation aDesignation) { SqlConnectionObj.Open(); string query = String.Format("INSERT INTO tbl_Designation VALUES('{0}','{1}')", aDesignation.Code, aDesignation.Title); SqlCommandObj.CommandText = query; SqlCommandObj.ExecuteNonQuery(); SqlConnectionObj.Close(); return true; }