public override void Update(Person person) { EmergencyContact ec = (EmergencyContact)person; CommonFunctions.UpdateApostrophe <EmergencyContact>(ec); StringBuilder sb = new StringBuilder(); sb.Append("UPDATE StudentEmergencyContact SET "); sb.Append("FullName ='" + ec.FullName + "'"); sb.Append(",Addr1='" + ec.Addr1 + "'"); sb.Append(",Addr2='" + ec.Addr2 + "'"); sb.Append(",Addr3='" + ec.Addr3 + "'"); if (ec.Addr4 != string.Empty) { sb.Append(",Addr4='" + ec.Addr4 + "'"); } sb.Append(",Postcode='" + ec.Postcode + "'"); sb.Append(",Phone='" + ec.Phone + "'"); sb.Append(",Relationship='" + ec.Relationship + "'"); sb.Append(" WHERE StudentEmergencyContactId =" + ec.StudentEmergencyContactId); string sql = sb.ToString(); dbc.ExecuteCommand(sql); }
public override List <Person> GetList(int PersonId) { List <Person> emergencyContactList = new List <Person>(); DataTable dt = dbc.GetDataTable("SELECT * FROM vw_StudentEmergencyContacts WHERE StudentId=" + PersonId); foreach (DataRow dr in dt.Rows) { var emergencyContact = new EmergencyContact { StudentEmergencyContactId = (int)dr["StudentEmergencyContactId"], PersonId = (int)dr["StudentId"], //FirstName = dr["FirstName"].ToString(), //LastName = dr["LastName"].ToString(), FullName = dr["FullName"].ToString(), Phone = dr["Phone"].ToString(), Addr1 = dr["Addr1"].ToString(), Addr2 = dr["Addr2"].ToString(), Addr3 = dr["Addr3"].ToString(), Addr4 = dr["Addr4"].ToString(), Postcode = dr["Postcode"].ToString(), Relationship = dr["Relationship"].ToString() }; emergencyContact.FullAddress = emergencyContact.GetFullAddress(); emergencyContactList.Add(emergencyContact); } return(emergencyContactList); }
public override void Remove(Person person, int StudentEmergencyContactId) { EmergencyContact ec = (EmergencyContact)person; StringBuilder sb = new StringBuilder(); sb.Append("DELETE FROM StudentEmergencyContact WHERE StudentEmergencyContactId=" + ec.StudentEmergencyContactId); string sql = sb.ToString(); //DBCommand db = new DBCommand(DBCommand.TransactionType.WithTransaction); dbc.ExecuteCommand(sql); //db.CommitTransactions(); //dbc.CloseConnection(); }
public override int Add(Person person, int StudentId) { EmergencyContact ec = (EmergencyContact)person; CommonFunctions.UpdateApostrophe <EmergencyContact>(ec); StringBuilder sb = new StringBuilder(); sb.Append("INSERT INTO StudentEmergencyContact (StudentId,FullName,Addr1,Addr2,Addr3,Addr4,Postcode,Phone,Relationship) VALUES ("); sb.Append(StudentId); sb.Append(",'" + ec.FullName + "'"); sb.Append(",'" + ec.Addr1 + "'"); sb.Append(",'" + ec.Addr2 + "'"); sb.Append(",'" + ec.Addr3 + "'"); if (ec.Addr4 != string.Empty) { sb.Append(",'" + ec.Addr4 + "'"); } else { sb.Append(",null"); } sb.Append(",'" + ec.Postcode + "'"); sb.Append(",'" + ec.Phone + "'"); sb.Append(",'" + ec.Relationship + "')"); //sb.Append(")"); string sql = sb.ToString(); //DBCommand db = new DBCommand(DBCommand.TransactionType.WithTransaction); int returnValue = dbc.ExecuteCommand(sql); //db.CommitTransactions(); //db.CloseConnection(); return(returnValue); }