public bool Add(BusDTO dto) { string query = "Insert into Bus values(@id,@bsx,@brand,@DateRegistration,@ownerId,@idTuyenDuong)"; SqlParameter[] sqlParameters = new SqlParameter[6]; sqlParameters[0] = new SqlParameter("@id", SqlDbType.NVarChar) { Value = dto.Id }; sqlParameters[1] = new SqlParameter("@bsx", SqlDbType.NVarChar) { Value = dto.BSX }; sqlParameters[2] = new SqlParameter("@brand", SqlDbType.NVarChar) { Value = dto.Brand }; sqlParameters[3] = new SqlParameter("@DateRegistration", SqlDbType.Date) { Value = dto.DateRegistration }; sqlParameters[4] = new SqlParameter("@ownerId", SqlDbType.NVarChar) { Value = dto.OwnerID }; sqlParameters[5] = new SqlParameter("@idTuyenDuong", SqlDbType.Int) { Value = dto.RouteID }; try { conn.ExecuteInsertQuery(query, sqlParameters); return(true); } catch (Exception ex) { throw ex; } }
public bool Add(StaffDTO dto) { bool check = true; string sql = "insert into Staff values (@MSNV,@CMND,@Name,@DateOfBirth,@Phone,@Role,@password) "; try { SqlParameter[] sqlParameters = new SqlParameter[7]; sqlParameters[0] = new SqlParameter("@MSNV", SqlDbType.NVarChar) { Value = dto.MSNV }; sqlParameters[1] = new SqlParameter("@CMND", SqlDbType.NVarChar) { Value = dto.CMND }; sqlParameters[2] = new SqlParameter("@Name", SqlDbType.NVarChar) { Value = dto.Name }; sqlParameters[3] = new SqlParameter("@DateOfBirth", SqlDbType.NVarChar) { Value = dto.Date }; sqlParameters[4] = new SqlParameter("@Phone", SqlDbType.NVarChar) { Value = dto.Phone }; sqlParameters[5] = new SqlParameter("@Role", SqlDbType.NVarChar) { Value = dto.RoleID }; sqlParameters[6] = new SqlParameter("@password", SqlDbType.NVarChar) { Value = dto.Password }; check = conn.ExecuteInsertQuery(sql, sqlParameters); } catch (Exception) { return(false); throw; } return(check); }
public bool Add(RouteDTO dto) { string query = "Insert into Route(TuyenDuong) values(@name)"; SqlParameter[] sqlParameters = new SqlParameter[1]; sqlParameters[0] = new SqlParameter("@name", SqlDbType.NVarChar) { Value = dto.TuyenDuong }; try { conn.ExecuteInsertQuery(query, sqlParameters); return(true); } catch (Exception ex) { throw ex; } }
public bool Add(BusStationDTO dto) { string query = "Insert into BusStation values(@BusID,@MSNVDRIVER,@DepartureTime,@TimeBack,@MSNVCAST,@Status)"; SqlParameter[] sqlParameters = new SqlParameter[6]; sqlParameters[0] = new SqlParameter("@BusID", SqlDbType.NVarChar) { Value = dto.BusID }; sqlParameters[1] = new SqlParameter("@MSNVDRIVER", SqlDbType.NVarChar) { Value = dto.MSNVDRIVER }; sqlParameters[2] = new SqlParameter("@TimeBack", SqlDbType.DateTime) { Value = dto.TimeBack }; sqlParameters[3] = new SqlParameter("@MSNVCAST", SqlDbType.NVarChar) { Value = dto.MSNVCAST }; sqlParameters[4] = new SqlParameter("@Status", SqlDbType.Int) { Value = dto.Status }; sqlParameters[5] = new SqlParameter("@DepartureTime", SqlDbType.DateTime) { Value = dto.DepartureTime }; try { conn.ExecuteInsertQuery(query, sqlParameters); return(true); } catch (Exception ex) { return(false); throw ex; } }
public bool Add(OwnerDTO dto) { string query = "Insert into Owner values(@id,@name,@phone,@DoB,@CMND,@address)"; SqlParameter[] sqlParameters = new SqlParameter[6]; sqlParameters[0] = new SqlParameter("@id", SqlDbType.NVarChar) { Value = dto.Id }; sqlParameters[1] = new SqlParameter("@name", SqlDbType.NVarChar) { Value = dto.Name }; sqlParameters[2] = new SqlParameter("@phone", SqlDbType.NVarChar) { Value = dto.Phone }; sqlParameters[3] = new SqlParameter("@DoB", SqlDbType.Date) { Value = dto.DateOfBirth }; sqlParameters[4] = new SqlParameter("@CMND", SqlDbType.NVarChar) { Value = dto.CMND }; sqlParameters[5] = new SqlParameter("@address", SqlDbType.NVarChar) { Value = dto.Address }; try { conn.ExecuteInsertQuery(query, sqlParameters); return(true); } catch (Exception ex) { Trace.TraceError(ex.Message); throw ex; } }